Error connecting with PGDBE

SqlQuery is a library and utility program that utilizes the best features of Xbase++ and eXpress++ for SQL browsing of data via ADSDBE, PGDBE and ODBCDBE.
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Error connecting with PGDBE

#11 Post 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.
The eXpress train is coming - and it has more cars.

bamunz@earthlink.net
Posts: 23
Joined: Fri Apr 17, 2015 11:09 am

Re: Error connecting with PGDBE

#12 Post 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.

bamunz@earthlink.net
Posts: 23
Joined: Fri Apr 17, 2015 11:09 am

Re: Error connecting with PGDBE

#13 Post 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.

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Error connecting with PGDBE

#14 Post 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.
The eXpress train is coming - and it has more cars.

Post Reply