[SQL] why query now work?

[Ruslan Zasukhin]

On 10/4/05 7:54 PM, "Leo Van den Brande" <leo_van_den_brande at wxs.nl> wrote:

> Hi Ruslan,
> 
> The previous log was with old database (v1). I now also ran the converted one,
> but I see no difference. Perhaps you do?


    PARAM: inQuery = "Select * from 'problems'"


Why you wrap table name by single quotes ???


Must be 

    Select * from problems
Or 
    Select * from [problems]        MS or Oracle style
OR
    Select * from "problems"        SQL92


The last 2 forms are needed if name have spaces


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