Only n runtime, ZQuery gives error with fklookup field: "Operation cannot be performed on an inactive dataset"
Posted: 13.08.2019, 15:30
Hi. I am using Lazarus 2.0.2 r60954, FPC 3.0.4 x86_64-win64-win32/win64 and ZeosLib 7.2.4 on PostgreSQL database.
When I configure ZQuery to show data from table "izp.izvod" and slave it to table "izp.banka" (Master source, linked fields, ...) everything works as it should be.
When I add fklookup field and configure it to get data from table "izp.user", in design everything is fine, data is shown.
But when I run it, as soon as ZQuery is to be activated, I get "EDatabaseError": "Operation cannot be performed on an inactive dataset"
Same setup with ZTable works without a problem.
Am I missing something? Is Lookup field (FieldKind = fkLookup) broken/non-functioning for ZQuery while it works with ZTable?
Bellow is relevant Debug Output:
Please tell me what further info you need.
When I configure ZQuery to show data from table "izp.izvod" and slave it to table "izp.banka" (Master source, linked fields, ...) everything works as it should be.
When I add fklookup field and configure it to get data from table "izp.user", in design everything is fine, data is shown.
But when I run it, as soon as ZQuery is to be activated, I get "EDatabaseError": "Operation cannot be performed on an inactive dataset"
Same setup with ZTable works without a problem.
Am I missing something? Is Lookup field (FieldKind = fkLookup) broken/non-functioning for ZQuery while it works with ZTable?
Bellow is relevant Debug Output:
Code: Select all
~"[New Thread 5896.0x1630]\n"
*running,thread-id="all"
=breakpoint-modified,bkpt={number="66",type="breakpoint",disp="keep",enabled="y",addr="0x0000000100018580",at="<fpc_raiseexception>",times="1",original-location="*4295067008"}
*stopped,reason="breakpoint-hit",disp="keep",bkptno="66",frame={addr="0x0000000100018580",func="fpc_raiseexception",args=[]},thread-id="1",stopped-threads="all"
(gdb)
<-data-evaluate-expression ^^shortstring(^POINTER($rcx)^+24)^^>
^done,value="'EDatabaseError'"
(gdb)
<x/s Exception($rcx).FMessage>
&"x/s Exception($rcx).FMessage\n"
~"0x100769db8 <_$DBCONST$_Ld52>:\t 'Operation cannot be performed on an inactive dataset'"
~"\n"
^done