Hi,
Details
Windows 7Pro 64Bit,
Delphi XE,
IBO Ver 4.9.11,
Firebird 2.5.0.26074 (64Bit)

I have a problem using the IBOQuery component, I am trying to run this SQL, if i load it into IBExpert it works perfectly, but when i load the following sql into my IBOQuery and then issue an IBOQuery.Execute it fails with the error "Problem in BindingCursor: Check Keylinks property"

I have read posts from many years ago, but i cannot see what i need to put in the keyklinks field to fix this problem, as i dont want a result dataset back am i using the correct component?

I have never understood the keylinks / Joinlinks fields and feel i need to take a day off to just understand where i have gone wrong.


'execute block AS ' +
'declare variable New_zpur integer; ' +
'begin ' +
' new_zpur = gen_id(acpur_gen, 1); ' +
' insert into acpur(ZPUR,ZNOM,ZSUP,ZSTATUS,ZVATCODE,ZEMP,ZSUPDLV, ' +
' ZEMPAUTH,ZCHASE,ZEMPORD,ZORDERBY,ZPED,ZPEDTXT,ZDATEORD,ZCONTACT, ' +
' ZTERMS,ZDELINS,ZBOOKIN,ZCAR,ZSUBT,ZVATAMT,ZTOTAL,ZEXCHANGE,ZPAID, ' +
' ZDATEPAID,ZSUPCONT )' +
' select :new_zpur,xp.ZNOM,xp.ZSUP,xp.ZSTATUS,xp.ZVATCODE,xp.ZEMP,xp.ZSUPDLV, ' +
' xp.ZEMPAUTH,xp.ZCHASE,xp.ZEMPORD,xp.ZORDERBY,xp.ZPED,xp.ZPEDTXT,xp.ZDATEORD,xp.ZCONTACT, ' +
' xp.ZTERMS,xp.ZDELINS,xp.ZBOOKIN,xp.ZCAR,xp.ZSUBT,xp.ZVATAMT,xp.ZTOTAL,xp.ZEXCHANGE,xp.ZPAID, ' +
' xp.ZDATEPAID,xp.ZSUPCONT ' +
' from acpur xp ' +
' where xp.zpur = 115 ; ' +
' insert into acpurit (ZPURIT,ZPUR,ZVATCODE,ZCTR,ZMATSPEC,ZQPAR,ZNOM,ZPRT,ZPICOFC,ZCERT,ZDATEREQ, ' +
' ZRITQTY,ZPARTNO,ZUNITS,ZRITDESC,ZPRICE,ZTOTAL,ZVATPCENT,ZPUOM,ZPDETAIL,ZASSY, ' +
' ZORD,ZFULLINV,ZPARTINV)' +
' select gen_ID(acpurit_gen,1),:new_zpur,xi.ZVATCODE,xi.ZCTR,xi.ZMATSPEC,xi.ZQPAR,xi.ZNOM,xi.ZPRT,xi.ZPICOFC,xi.ZCERT,xi.ZDATEREQ, ' +
' xi.ZRITQTY,xi.ZPARTNO,xi.ZUNITS,xi.ZRITDESC,xi.ZPRICE,xi.ZTOTAL,xi.ZVATPCENT,xi.ZPUOM,xi.ZPDETAIL,xi.ZASSY, ' +
' xi.ZORD,xi.ZFULLINV,xi.ZPARTINV ' +
' from acpurit xi ' +
' where xi.zpur = 115;' +
'end '


Thanks in anticipation....

Colin Coleman