Page 2 of 2

Re: Error connecting with PGDBE

Posted: Wed Apr 08, 2020 8:18 am
by rdonnay
If you study my code in SqlQuery.Prg (approximately line 5038) you will see that it is different than the code that you posted.

Code: Select all

  oPgStatement := DacSqlStatement(oSession):FromChar(cStatement)
  oPgStatement:Build():Query(,cAlias)
Try changing your code to the above.
I am passing a pointer to the DacSession() object.
Also, I use the :Query() method rather than :Execute().

Working with PGDBE has been very difficult.
It is poorly documented. I had to learn thru a lot of hacking.

Re: Error connecting with PGDBE

Posted: Wed Apr 08, 2020 8:53 am
by bamunz@earthlink.net
Yes it is very annoying because it seems Alaska has waste 3 years with ISAM emulation that could have been put in the SQL passthru and CXP.
I have had no problems with the speed of PGDBE using SQL but not sure I can overcome the lack of documentation and support.

Re: Error connecting with PGDBE

Posted: Wed Apr 08, 2020 9:34 am
by bamunz@earthlink.net
That did the trick FYI it was the query method instead of execute not sure why it works on the single table selects.


Thanks Roger.

Re: Error connecting with PGDBE

Posted: Wed Apr 08, 2020 9:40 am
by rdonnay
it seems Alaska has waste 3 years with ISAM emulation
Alaska has been talking about writing their own client/server solution since 2001.
They have been talking about PostGreSql for at least 10 years yet they still have a very poor implementation.