Error connecting with PGDBE

[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.

[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.

[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.

[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.