Migrating PB 10.2 to 12.0 Classic problem

[lookashp]

Hi,
in PowerBuilder 10.2 when I wanted to get something from database I used for ex. :

SELECT "dbo"."aaaa"."bbb"
FROM "dbo"."aaaa"
USING ... and It works.

After the migration to latest PB version keep receiving invalid syntax warning. When I change syntax to
SELECT dbo.aaaa.bbb
FROM dbo.aaaa
then It is OK, byt I can't do it because it's used almost 10000 times.

Does anyone know if it is possible to change any options and force PB 12 to accept " mark ?


I use ODBC connection to SQL Server 2005

 

[mbalent]

My ole db connection to SQL server has under the 'syntax' tab an 'Enclose Table and Column Names in Quotes' check box. I'm not sure if this applies or not.

Matt

"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[lookashp]

I've had it already checked