Alaska Software Inc. - dbUseArea with Query
Alaska Software Inc. - dbUseArea with Query
Username: Password:
AuthorTopic: dbUseArea with Query
Michael PapstdbUseArea with Query
on Thu, 23 Nov 2017 09:47:19 +0100
Hello,

I'm using PGDBE for validation, but there are lot of problems, like 
dbSetFilter with complex conditions.

So I want to use a query to get the filtered dataset.

My example:

|cAName := "persplan" //Alias-Name cQuery := "SELECT * FROM persplan 
WHERE abrjahr='2017' ORDER BY abrjahr,persnr,jahr,woche;" //Query with 
WHERE-clause and ORDER BY ||USE (cQuery) ALIAS (cAName) SHARED NEW VIA (_oSession) //Open Table via 
_oSession (_oSession is connected with PGSQL-Server |The table has only 7 columns, but >450000 datasets, filtered about 60000 datasets.


The result of opening the table is a XPPERROR:

|------------------------------------------------------------------------------ 
FEHLERPROTOKOLL von "M:\Daten\Test\PASSSQL.EXE" Datum: 22.11.2017 
09:18:10 Xbase++ Version : Xbase++ (R) Version 2.00.853 Betriebssystem : 
Windows 10 1709 Build 16299 Programm : M:\Daten\Test\PASSSQL.EXE 
Programmdetails : PASSSQL.EXE - vom: 22.11.2017 / 09:17:39 - Größe: 
53117952 Bytes Version : 4.21.01 vom 13.11.2017 Rechner : ****-PC 
Speicher : 2048.00 von 2048.00 MB frei Userinfo : **** aktueller Pfad : 
M:\Daten\Test PSP Nutzer : Firma 001 Bearbeiter: Threads : {{1, 1124, 
537, "ERRORLOG", thread}, {3, 1652, 3013, "MAGICHELP:EXECUTE", 
MagicHelp}, {4, 2332, NIL, NIL, NIL}} 
------------------------------------------------------------------------------ 
Workspacelist() : {} Alias() : leer Recno() : leer Found() : NO 
NetError() : NO Select() : 1 IndexOrd() : 0 
------------------------------------------------------------------------------ 
WorkSpaceList : 
------------------------------------------------------------------------------ 
ADAC20B.DLL : 2.0.0853 ADAC20C.DLL : 2.0.0853 ASCOM10.dll : 2.0.0853 
ASCOM10C.dll : 2.0.0853 AsiNet10.dll : 2.0.0853 ASMP10.DLL : 1.90.0331 
ASRDBC10.DLL : 2.0.0853 BAP.DLL : 2.0.0853 comerr32.dll : 1.6-kfw-3.2.1 
DBFDBE.DLL : 2.0.0853 dbfupsize.dll : 2.0.0853 DELDBE.DLL : 2.0.0853 
DXE.DLL : 1.90.0355.19 gssapi32.dll : 1.6-kfw-3.2.1 k5sprt32.dll : 
1.6-kfw-3.2.1 krb5_32.dll : 1.6-kfw-3.2.1 libeay32.dll : 0.9.8e 
libpqex.dll : 8.3.1 msvcr71.dll : 7.10.3052.4 NTXDBE.DLL : 2.0.0853 
OT4Xb.dll : 1.6.4.40 pgdbe.dll : 2.0.0853 pgutil.dll : 2.0.0853 
rtfedit.dll : 1.06.01 SDFDBE.DLL : 2.0.0853 ssleay32.dll : 0.9.8e 
XbtBase1.dll : 2.0.0853 XBTBase2.dll : 2.0.0853 XbZLib.dll : 2.00.146 
XPPDBGC.DLL : 2.0.0853 xppdui.dll : 2.0.0853 XPPNAT.DLL : 2.0.0853 
XPPRT1.DLL : 2.0.0853 XPPRT2.DLL : 2.0.0853 XPPSYS.DLL : 2.0.0853 
XPPUI1.DLL : 2.0.0853 XPPUI2.DLL : 2.0.0853 
------------------------------------------------------------------------------ 
oError:args : -> VALTYPE: L VALUE: .T. -> VALTYPE: O CLASS: dacSession 
-> VALTYPE: C VALUE: SELECT * FROM PERSPLAN WHERE ABRJAHR='2017' ORDER 
BY ABRJAHR,PERSNR,JAHR,WOCHE; -> VALTYPE: C VALUE: PERSPLAN -> VALTYPE: 
L VALUE: .T. -> VALTYPE: L VALUE: .F. oError:canDefault : J 
oError:canRetry : J oError:canSubstitute: N oError:cargo : NIL 
oError:description : Datei kann nicht ge”ffnet werden oError:filename : 
oError:genCode : 71 oError:operation : DbUseArea oError:osCode : 0 = Der 
Vorgang wurde erfolgreich beendet. oError:severity : 2 oError:subCode : 
8999 oError:subSystem : BASE oError:thread : 1 oError:tries : 1 
------------------------------------------------------------------------------ 
CALLSTACK: 
------------------------------------------------------------------------------ 
Aufgerufen von OPEN_DB(466) Aufgerufen von MAIN(720) ||Using "USE (cAName) ALIAS (cAName) SHARED NEW VIA (_oSession) //Open 
Table via _oSession (_oSession is connected with PGSQL-Server" does 
works, but loads all the datasets. I'm using complex SELECT-Querys with 
ODBCDBE on MSSQL-Databases on Xbase++ 1.9 (and 2.0) for years, these are 
working correctly. Is there a unknown problem in PGDBE? With kind 
regards Michael |

||