Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Mon, Sep 29 2008 6:55 PM	Permanent Link
KP	Hi All ~ did I miss some reference in the manuals? It seems that reserved words (SELECT in my case) may not be part of column names. Had the following fail: ....JOIN SELECTION J on (D.SelectID = J.SelectID)... It runs fine after renaming the SelectID column Is this by design or a bug? TIA KP
Tue, Sep 30 2008 10:53 AM	Permanent Link
Fernando Dias Team Elevate	KP, I couldn't reproduce this. The statement SELECT Select FROM Select WHERE Select='select' runs fine here. Can you post the entire statement? -- Fernando Dias [Team Elevate]
Tue, Sep 30 2008 11:00 AM	Permanent Link
Fernando Dias Team Elevate	.... also, what's the error message and what version are you using? -- Fernando Dias [Team Elevate]
Tue, Sep 30 2008 6:05 PM	Permanent Link
KP	4.26 Build 3 Strange - I had to quote these columns name yesterday for it to work but today (as I am trying to reproduce the exact error message for you) it works as expected ??? Maybe some caching? Don't remember whether I rebooted or not... Sorry for any confusion! KP