Okay, let me try to explain what I am trying to do.

I am inserting a record into table e_project, using TIB_DSQL. The SQL for that TIB_DSQL is EXECUTE PROCEDURE <my proc(params1..paramsn). That works fine.
Now when I retrieve a dataset with can contain multiple records, also using TIB_DSQL I am not seeing the synchornised data.

If output fields in a selectable SP are cooked at execution time, is any synchronisation needed/possible?

My preference is to use an selectable SP, what are my options?

Thanks again for your help!
Ronan

>>If this doesn't direct you to a solution to your problem, could you state
>>the actual problem again?
>>
>>Helen

[Non-text portions of this message have been removed]