Subject | Re: TIBOqueries parameter problem |
---|---|
Author | Patrick Z Lenz |
Post date | 2001-01-26T19:49:40Z |
Hi Jason,
I did some more testing with clientdatasets and iboqueries with
SELECT * FROM SPROC(:MinValue,:MaxValue)
You should find that the clientdataset will not show any records for
stored procedures with 2 or more parameters.
That's different from Tquery or IBX's IBQuery and that's why i got
stuck.
My workaround is to specify some default values for the params within
iboquery. They will be overridden by the clientdataset anyway but it
won't work if you don't have them.
Regards
Patrick
I did some more testing with clientdatasets and iboqueries with
SELECT * FROM SPROC(:MinValue,:MaxValue)
You should find that the clientdataset will not show any records for
stored procedures with 2 or more parameters.
That's different from Tquery or IBX's IBQuery and that's why i got
stuck.
My workaround is to specify some default values for the params within
iboquery. They will be overridden by the clientdataset anyway but it
won't work if you don't have them.
Regards
Patrick