3.5b11 SQL exception

[Ruslan Zasukhin]

On 29/11/07 12:45 AM, "Barry G. Sumpter" <barry at noodlebox.com.au> wrote:

> No.  The double quotes in the sql - for the reserved word error.
> 
> Was this available in v3.1?

Double quotes works starting from 3.0

May be you just not escape them?
    if you write in RB you need something as

    query =  "SELECT \"keywords\", fld2 FROM T2"


Also you can use []

    query =  "SELECT [keywords], fld2 FROM T2"


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