[TIP] conflict with KEY WORDS

[Ruslan Zasukhin]

On 4/8/07 7:46 PM, "yoann besnard" <yobesnar at gmail.com> wrote:

> In the past I created a table called "event" It was impossible to query the
> database via the SQL way (kernel defect all the time). Two days ago my problem
> was due to a table called "user". It was also impossible to query the table
> via the SQL way (kernel defect all the time) . I changed the table name to
> "users". Stil the same problem. When I modified the table name for "members",
> it was possible to query the table via SQL. But in all cases if I used the API
> way, no problems occured.
> 
> Is there anywhere some reserved table names in Valentina?

http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:documen
tation:vsql:reference:reference

I again want repeat this TIP:

    * name tables as tblName
    * name fields as fldName
    
Save sometimes a lots of time :)


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