3.5b11 SQL exception

[Barry G. Sumpter]

Righto!

Should have thought of the [] myself.

Thanks.



-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net] On Behalf Of Ruslan Zasukhin
Sent: Thursday, 29 November 2007 7:34 AM
To: valentina at lists.macserve.net
Subject: Re: 3.5b11 SQL exception

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]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina