Hi, we have an application in Powerbuilder 5 wich we are now trying to port to pb12 version, as pb5 is now too old for new S.O. ... Anyway, we installed pb 12.5 with sql anywhere 12 (64 and 32 bit version) on a win 2008 64 bit server. After migrating our application , when trying to launch it we have strange errors with embedded sql. Example : executing this

select "table"."field"
into :myvar 
from "table"
where (conditions)
using mytransaction;

returns this error:

SQLSTATE = 37000
[Sybase][ODBC Driver][Adaptive Server Anywhere]Syntax error near 'field' on line 1
the same thing happens with sql anywhere 5, 9 and 12. If I clear the quotations from sql statement it works fine:
select table.field
into :myvar 
from table
where (conditions)
using mytransaction;
this works fine.

I believe there is something wrong in my system configuration...maybe I'have to modify in some way the pbodb125.ini, but i don't know how...

Any suggestion will be appreciated!!! p.s. sorry for my english.

This question is marked "community wiki".

asked 31 May '12, 07:31

AndrewGenoa's gravatar image

AndrewGenoa
61126
accept rate: 0%

edited 31 May '12, 16:10

Calvin%20Allen's gravatar image

Calvin Allen
1.5k232638


I solved by myself by putting the option DelimitIdentifier='YES' for the connection to the DB.

permanent link

answered 31 May '12, 11:02

AndrewGenoa's gravatar image

AndrewGenoa
61126
accept rate: 0%

Hi,

Where do you put the option DelimitIdentifier='YES'?

Thanks

permanent link

answered 24 Feb '16, 14:22

zalman's gravatar image

zalman
10
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×35

question asked: 31 May '12, 07:31

question was seen: 1,537 times

last updated: 24 Feb '16, 14:22