SQL?

[Ruslan Zasukhin]

On 06/28/12 4:03 AM, "Robert Mann" <robmann at gp-racing.com> wrote:

Hi Robert,

> The following does not seem to be working anyone with a idea as to why?
> 
> global gbrand
> 
> put "SELECT yrmodsize FROM stockvalving WHERE stockvalving.brand='" & gbrand
> & "' ORDER BY yrmodsize DESC" into theSQL
> put VDataBase_SqlSelect(mDatabase, theSQL) into curID

1) what error number/string?

2) did you check SQL string you get ?

3) did you try this SQL string from Valentina Studio against you db ?


-- 
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]