| Subject | Re: [IBO] Refresh on 'Select * from ' isn't working? |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-11-07T07:03:49Z |
At 08:59 AM 07-11-01 +0200, you wrote:
Regards,
Helen
>Hi,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.
>
>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...)
Regards,
Helen