Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10963
| 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> |
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
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