Only n runtime, ZQuery gives error with fklookup field: "Operation cannot be performed on an inactive dataset"

The forum for ZeosLib 7.2 Report problems. Ask for help, post proposals for the new version and Zeoslib 7.2 features here. This is a forum that will be edited once the 7.2.x version goes into RC/stable!!

My personal intention for 7.2 is to speed up the internals as optimal a possible for all IDE's. Hope you can help?! Have fun with testing 7.2
Post Reply
DrLove73
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 13.08.2019, 15:01

Only n runtime, ZQuery gives error with fklookup field: "Operation cannot be performed on an inactive dataset"

Post by DrLove73 »

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:

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
Please tell me what further info you need.
User avatar
EgonHugeist
Zeos Project Manager
Zeos Project Manager
Posts: 1936
Joined: 31.03.2011, 22:38

Re: Only n runtime, ZQuery gives error with fklookup field: "Operation cannot be performed on an inactive dataset"

Post by EgonHugeist »

Could you make a small example and open a ticket on our bugtracker?
Best regards, Michael

You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image
Post Reply