At 02:58 PM 18/02/2004 +0000, you wrote:

>Helen,
>Thanks for the assistance, I will implement your suggestions tonight.
>One question though, I am not sure I understand how I am getting the
>record ID back without the suspend?

Because it's a return parameter. IBO always makes any return parameters
from executable SPs available in the Fields[] array.

Suspend is only for returning multi-row datasets. In executable SPs it's
exactly the same as Exit and shouldn't be there.

>I could have swore I tried it without it before and I never got the
>ID back.

Maybe you tried to read it from Params[] before?

>Oh, and actually the db_query is a cursor component. I used that
>because I thought it did not cache all the metadata and would be
>faster for a middle tier server.
>
>So using the cursor component is bad for this type of operation?

No, it's OK, as long as you use it for *executing* the SP, not selecting
it. Just use it exactly like the ib_dsql example. There's some extra
overhead, but not much.

g'night
Helen