bb.donnay-software.com

It is the same for me alot of transaction issues. It is definitely some Network issue but I don't see a windows update that has caused it.

Regan,

Were you able try this I did it work for you?

Tom,

I am having same issues Reagan is describing but that link you posted is not working.
Do you know what I can search for under Windows doc?

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.

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.

Yes it works with SqlQuery and pgadmin but that command I posted errors out.

I posted following message on The Alaska Forum last week and have also run the SQL with SqlQuery successfully. I have been testing with Postgres with the PGDBE and this is first multi-table select I have tried. cSQL = "SELECT loan.*, customer.l_name, customer.f_name, customer.mi, customer.generation...

It was in the SqlQuery20 folder with exe but not in path.

Thanks

The error is in loading the DBE in SqlQueryConnection:ConnectPg

IF !('PGDBE'$aDbeList) .AND. !DbeLoad( "PGDBE",.f.)
DC_WinAlert('Database-Engine PGDBE not loaded')
RETURN .f.
ENDIF

I am on 2.0.158 and when I go to help and Download Latest Version it says it is latest version.
Where do I get 2.0.159?