Subject | keylinks keysource and select sp |
---|---|
Author | jeffplata |
Post date | 2006-03-13T06:44:17Z |
(Using IBO 4.5B)
Is it possible to define a lookup relationship using keylinks/keysource
between two ib_queries where one gets data from a stored procedure?
Something in this manner:
mainquery:
sql='select gl, sl, dramount, cramount from rp_tbsl(:period)';
lookupquery:
sql='select gl, description from accounts';
keylinks='accounts.gl=?????? // what goes here?
keysource=ib_datasource1
ib_datasource1:
dataset=mainquery;
Is it possible to define a lookup relationship using keylinks/keysource
between two ib_queries where one gets data from a stored procedure?
Something in this manner:
mainquery:
sql='select gl, sl, dramount, cramount from rp_tbsl(:period)';
lookupquery:
sql='select gl, description from accounts';
keylinks='accounts.gl=?????? // what goes here?
keysource=ib_datasource1
ib_datasource1:
dataset=mainquery;