(no subject)

[Ruslan Zasukhin]

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]