SQL syntax problem

[Bart Pietercil]

I work with "_" all the time. Should be something else.


On 6-mrt-07, at 01:50, Ruslan Zasukhin wrote:

> On 6/3/07 2:41 AM, "Robert Mann" <robmann at gp-racing.com> wrote:
>
> Hi Robert,
>
>> The sql statement returns record in mysql but not valentine
>>
>> put "SELECT Year_Model FROM yearmodelsize WHERE  
>> yearmodelsize.BID='" &
>> gbrandid & "' and yearmodelsize.stock_specs_complete='no' ORDER BY
>> Year_Model DESC" into theSQL
>>
>>
>>
>> yet this one work with both
>>
>> put "SELECT yrmodsize FROM stockvalving WHERE  
>> stockvalving.brand='" & gbrand
>> & "'ORDER BY yrmodsize DESC;" into theSQL2
>>
>>
>>
>> could it be that valentina does not like _  ?
>
> In the name of field?
> Should work of course.
>
> Can be glitch of SQL parser.
>
> Sergey, please check this.
>
> -- 
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina