Subject Re: [IBO] Refresh on 'Select * from ' isn't working?
Author Helen Borrie
At 08:59 AM 07-11-01 +0200, you wrote:
>I have a TIBOQuery with a 'Select * from MyStoredProc(:MyMasterField)'
>linked as a detail dataset to an another master table. The master-detail
>relationship works correctly, but when I do an Refresh on the detail table,
>I don't see any updates. (with Close/Open pair it works AFAIK, but...)

The reason for this is that a stored procedure doesn't have an underlying table so, if something changes in one of the tables from which the proc outputs the set, there is no underlying linkage to a table to permit a row refresh.