Search found 23 matches

by bamunz@earthlink.net
Fri Apr 17, 2020 6:13 am
Forum: Xbase++ Support
Topic: Database access errors
Replies: 19
Views: 33037

Re: Database access errors

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.
by bamunz@earthlink.net
Thu Apr 16, 2020 10:50 am
Forum: Xbase++ Support
Topic: Database access errors
Replies: 19
Views: 33037

Re: Database access errors

Regan,

Were you able try this I did it work for you?
by bamunz@earthlink.net
Thu Apr 16, 2020 8:46 am
Forum: Xbase++ Support
Topic: Database access errors
Replies: 19
Views: 33037

Re: Database access errors

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?
by bamunz@earthlink.net
Wed Apr 08, 2020 9:34 am
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Re: Error connecting with PGDBE

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.
by bamunz@earthlink.net
Wed Apr 08, 2020 8:53 am
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Re: Error connecting with PGDBE

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.
by bamunz@earthlink.net
Wed Apr 08, 2020 7:40 am
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Re: Error connecting with PGDBE

Yes it works with SqlQuery and pgadmin but that command I posted errors out.
by bamunz@earthlink.net
Tue Apr 07, 2020 2:47 pm
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Error on Multi-table Select

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...
by bamunz@earthlink.net
Tue Apr 07, 2020 1:36 pm
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Re: Error connecting with PGDBE

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

Thanks
by bamunz@earthlink.net
Tue Apr 07, 2020 11:01 am
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Re: Error connecting with PGDBE

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
by bamunz@earthlink.net
Tue Apr 07, 2020 8:29 am
Forum: SqlQuery
Topic: Error connecting with PGDBE
Replies: 13
Views: 27794

Re: Error connecting with PGDBE

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?