bb.donnay-software.com

Donnay Software Web Forums
It is currently Sat May 30, 2020 11:54 pm

All times are UTC - 7 hours




Post new topic Reply to topic  [ 14 posts ]  Go to page Previous  1, 2
Author Message
PostPosted: Wed Apr 08, 2020 8:18 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
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:
  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.


Top
 Profile  
 
PostPosted: Wed Apr 08, 2020 8:53 am 
Offline

Joined: Fri Apr 17, 2015 11:09 am
Posts: 23
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.


Top
 Profile  
 
PostPosted: Wed Apr 08, 2020 9:34 am 
Offline

Joined: Fri Apr 17, 2015 11:09 am
Posts: 23
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.


Top
 Profile  
 
PostPosted: Wed Apr 08, 2020 9:40 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
Quote:
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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 14 posts ]  Go to page Previous  1, 2

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group