Subject | Re: [IBO] Confusion about StoredProc vs use of Cursor or Query (was Help with OnCallBack) |
---|---|
Author | Chuck Belanger |
Post date | 2005-07-06T05:48:48Z |
Thank you, again for your response.
Your detailed answer will most definitely help me out with that final solution to
actually filling my Grid with the results of the search--that would certainly be my
next issue!
But, before I try what you suggested, it seems you missed that my test app has been
using the simple
SELECT * FROM MYSP(:K)
and that SP returned ALL rows from MyTable (MasterLibrary), and yet there was no
firing of the OnCallBack event.
Is it the fact that you have the
if (f_substr(UPPER(W), MLUPITEM) > -1) THEN
MLID = TMPID;
ELSE
MLID = NULL;
before the SUSPEND that makes the difference in getting a Fetching event? Or am I
missing something, again?
I'm off to try out your suggestion one way or the other, because ultimately your
answer will be part of my search and display routine.
Thank you, again,
Chuck
Your detailed answer will most definitely help me out with that final solution to
actually filling my Grid with the results of the search--that would certainly be my
next issue!
But, before I try what you suggested, it seems you missed that my test app has been
using the simple
SELECT * FROM MYSP(:K)
and that SP returned ALL rows from MyTable (MasterLibrary), and yet there was no
firing of the OnCallBack event.
Is it the fact that you have the
if (f_substr(UPPER(W), MLUPITEM) > -1) THEN
MLID = TMPID;
ELSE
MLID = NULL;
before the SUSPEND that makes the difference in getting a Fetching event? Or am I
missing something, again?
I'm off to try out your suggestion one way or the other, because ultimately your
answer will be part of my search and display routine.
Thank you, again,
Chuck