GRID - OnQueryData
Posted: Fri Dec 08, 2017 1:47 pm
Hi All
I'm trying to change data source from DBF to postgresql using (virtual grid)
I have connection to postgresql via RDD.
Source of data is result of the query.
oQuery:- .....
aTable:=PQRESULT2ARRAY(oQuery:pQuery)
Function onsqlquery
This.QueryData := aTable[This.QueryRowIndex] [This.QueryColIndex]
Return Nil
In object inspector - bookmark "function" of the grid control
OnQueryData onsqlquery()
All working properly.
DoubleClick on row in grid returns correct value (for example: 10)
The problem appears when i try to locate and highlight (to point) correct row in a grid assigning value.
ControlName.GridName.value:=10
Result
Date:2017.12.06 Time: 14:54:44
Error BASE/1132 Error range of array: incorect number of arguments
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5702)
Called from DOMETHOD(9003)
Called from QHASLA(16)
Called from HB_EXECFROMARRAY(0)
Called from (b)MAIN(161)
Called from _DOCONTROLEVENTPROCEDURE(6041)
Called from EVENTS(1741)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5702)
Called from DOMETHOD(9003)
Called from QWSTEP_LOGOWANIE(273)
Called from WSTEP(712)
Called from SPLASHDELAY(1045)
Called from (b)SPLASH(4)
Called from _PROCESSINITPROCEDURE(5861)
Called from _ACTIVATEWINDOW(5689)
Called from DOMETHOD(9003)
Called from SPLASH(1035)
Called from (b)MAIN(4)
Called from _PROCESSINITPROCEDURE(5861)
Called from _ACTIVATEWINDOW(5612)
Called from DOMETHOD(9003)
Called from MAIN(631)
It is possible to point (highlight) correct row in virtual grid assigning value or other way ?
Regards/Saludos
Rafał
I'm trying to change data source from DBF to postgresql using (virtual grid)
I have connection to postgresql via RDD.
Source of data is result of the query.
oQuery:- .....
aTable:=PQRESULT2ARRAY(oQuery:pQuery)
Function onsqlquery
This.QueryData := aTable[This.QueryRowIndex] [This.QueryColIndex]
Return Nil
In object inspector - bookmark "function" of the grid control
OnQueryData onsqlquery()
All working properly.
DoubleClick on row in grid returns correct value (for example: 10)
The problem appears when i try to locate and highlight (to point) correct row in a grid assigning value.
ControlName.GridName.value:=10
Result
Date:2017.12.06 Time: 14:54:44
Error BASE/1132 Error range of array: incorect number of arguments
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from C_MSGSTOP(0)
Called from SHOWERROR(181)
Called from DEFERROR(129)
Called from (b)ERRORSYS(66)
Called from ONSQLQUERY(1583)
Called from (b)QHASLA(425)
Called from EVENTS(3049)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5702)
Called from DOMETHOD(9003)
Called from QHASLA(16)
Called from HB_EXECFROMARRAY(0)
Called from (b)MAIN(161)
Called from _DOCONTROLEVENTPROCEDURE(6041)
Called from EVENTS(1741)
Called from DOMESSAGELOOP(0)
Called from _ACTIVATEWINDOW(5702)
Called from DOMETHOD(9003)
Called from QWSTEP_LOGOWANIE(273)
Called from WSTEP(712)
Called from SPLASHDELAY(1045)
Called from (b)SPLASH(4)
Called from _PROCESSINITPROCEDURE(5861)
Called from _ACTIVATEWINDOW(5689)
Called from DOMETHOD(9003)
Called from SPLASH(1035)
Called from (b)MAIN(4)
Called from _PROCESSINITPROCEDURE(5861)
Called from _ACTIVATEWINDOW(5612)
Called from DOMETHOD(9003)
Called from MAIN(631)
It is possible to point (highlight) correct row in virtual grid assigning value or other way ?
Regards/Saludos
Rafał