Skip site navigation (1) Skip section navigation (2)

Re: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: alepaes - aldeia digital <alepaes(at)aldeiadigital(dot)com(dot)br>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons
Date: 2008-06-11 00:57:08
Message-ID: 484F22E4.1030507@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
alepaes - aldeia digital wrote:
> Sorry,
> 
> I mean: "PGODBC 8.03.0200 have the same problem"
> 
> 
> alepaes - aldeia digital wrote:
>> Hi,
>>
>> Postgresql 8.2.3 have the same problem:
>>
>> <192.168.1.10>ERROR:  syntax error at or near "read" at character 487
>> <192.168.1.10>STATEMENT:  declare "SQL_CUR01B5BDE8" cursor for  SELECT 
>> ct12emp04, ct12numlot, ct12numlan, ct12dtlanc, ct12docume, ct12empcc1, 
>> ct12empcc2,   ct12empcc3, ct12emptr1, ct12emptr2, ct12emptr3, 
>> ct12dtdig, ct12tradu1, ct12ccust1,   ct12tradu2, ct12ccust2, 
>> ct12tradu3, ct12ccust3, ct12valor, ct12histo1, ct12histo2,   
>> ct12histo3, ct12histo4, ct12histo5, ct12histo6, ct12renume, 
>> ct12origem  FROM CT12T   WHERE ct12emp04 = '500' AND ct12numlot = 
>> '20080532' AND ct12numlan = '52' FOR UPDATE OF CT12T  for read 
>> only;fetch 100 in "SQL_CUR01B5BDE8"

Could you try the driver testing for 8.3.0201 at
   http://www.geocities.jp/inocchichichi/psqlodbc/index.html
?

regards,
Hiroshi Inoue


In response to

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2008-06-11 04:06:13
Subject: what gives: SELECT INVALID SELECT STATEMENT TO FORCE ODBC DRIVER TO UNPREPARED STATE
Previous:From: alepaes - aldeia digitalDate: 2008-06-10 17:32:01
Subject: Re: Re: " for read only" clause appended for safety when UseDeclareFetch=1 breaks some sql statements with trailing semicolons

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group