Subject | Stored Procedure / Fields not Displayed |
---|---|
Author | jaguarius2003 |
Post date | 2004-08-12T16:39:04Z |
Hi,
I created a stored procedure to do some calculations for me a few
months ago and put it into my program at that time. It has been
working fine but recently I needed to add a few return fields and
update the procedure.
I was using a Stored_Proc control, but I switched to a IB_Query. For
some reason, the new fields show up when the dataset is made active at
deisgn time but they will not show up in a control or a grid while the
program is running. I am perplexed as to the cause.
Is there a limit on the number of fields that can be returned by a
stored proc, or can anyone suggest a different cause?
Thanks,
Jason S. Gagnon
I created a stored procedure to do some calculations for me a few
months ago and put it into my program at that time. It has been
working fine but recently I needed to add a few return fields and
update the procedure.
I was using a Stored_Proc control, but I switched to a IB_Query. For
some reason, the new fields show up when the dataset is made active at
deisgn time but they will not show up in a control or a grid while the
program is running. I am perplexed as to the cause.
Is there a limit on the number of fields that can be returned by a
stored proc, or can anyone suggest a different cause?
Thanks,
Jason S. Gagnon