Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10963

VO2ADO RDD for Postgres

Newsgroups comp.lang.clipper.visual-objects
Date 2017-09-09 01:14 -0700
Message-ID <9dd67ec8-aacb-4300-b39e-099efb640c2f@googlegroups.com> (permalink)
Subject VO2ADO RDD for Postgres
From Frank M <frank_muessner@gmx.de>

Show all headers | View raw


Hello, 

i am starting with VO2ADO and playing with samples. 

I tray to connect to a PostgreSQL.
When Open a Table WITH Boolean Column with AdoServer:

oSrv := Adoserver("bjour",oConn,adOpenKeyset, adLockOptimistic,adCmdTable)
? oSrv:Gotop()  
? oSrv:FIELDGET(#datev)  
? oSrv:Append()
? oSrv:FIELDPUT(#datev,TRUE)
wait
oSrv:close()

I can Append a new Record. 


Same with RDD:

RddSetDefault("Vo2Ado")                    
oServer := AdoDbServer{"bjour"}
? oServer:GoTop()
? oServer:Append()
? oServer:FIELDPUT(#datev,TRUE)
? oServer:Close()

WAIT


There i get the Error:
Error Code 24[WRITE ERROR]
Subsystem VO2ADO
Error SubCode: 2009 (Append)

Description ERROR:  invalid input syntax for type boolean: "   ";


This is only with Tables that have boolean Fields. OK, Error came from this Column. 

I test with ODBC Driver:
"Provider=MSDASQL.1;Persist Security Info=False;Data Source=PostgreSQL30"

and Olebd  
[Provider=PGNP.1;Integrated Security="";Password=xxxx;Persist Security Info=true;User ID=postgres;Initial Catalog=wq20170906123331;Data Source=xxx.xxx.xxx.xxx;Extended Properties="SSL=allow;";Location="";Mode=ReadWrite;Use Procedure for Prepare=1;Auto Translate=true;Packet Size=4096;Application Name="";Workstation ID="";Use Encryption for Data=False;Tag with column collation when possible=False]


Is there a Option for the RDD from VO2ADO that i have set for Boolean Fields? I found nothing.

Have someone a note where i can look?

Regard Frank 
 



 

Back to comp.lang.clipper.visual-objects | Previous | Next — Next in thread | Find similar | Unroll thread


Thread

VO2ADO RDD for Postgres Frank M <frank_muessner@gmx.de> - 2017-09-09 01:14 -0700
  Re: VO2ADO RDD for Postgres Robert van der Hulst <rjvanderhulst@gmail.com> - 2017-09-10 06:41 -0700
  Re: VO2ADO RDD for Postgres Frank M <frank_muessner@gmx.de> - 2017-09-11 01:39 -0700
    Re: VO2ADO RDD for Postgres Robert van der Hulst <rjvanderhulst@gmail.com> - 2017-09-11 02:43 -0700
  Re: VO2ADO RDD for Postgres Frank M <frank_muessner@gmx.de> - 2017-09-11 07:43 -0700

csiph-web