Devart Forums

Hi,

I have an application written in Delphi 7 with an Interbase 7 database.

The application runs in a multi-user environment and I was wondering what is the most efficient way to refresh my view of the data in order to reflect changes made by other users.

Many thanks,

Michael

Call the Refresh method of TIBCQuery to refresh the data. You can call this method when a user presses some button or selects an item from the program menu. You can also use TTimer component to call the Refresh method periodically.

Hi
Thank you for your quick response.
Unfortunately I have used Refresh several times to obtain the underlying data but the values from computed fields do not appear on the application.
I have even tried opening and closing the query, to no avail. The data from these computed fields does eventually appear if I move onto another record and back.
Additional information
I am using a masterdetail relationship with the computed data on the detail.
I have also tried IBCQuery1.params.

Many thanks

Michael

We could not reproduce the problem. Please specify, do you mean computed fields in the database table, or Delphi calculated fields?

Thanks for your prompt reply.

The computed fields are actually in the database.

For example :

TOTALK121 COMPUTED BY (oneofftotalK120+materialtotalK118+
fabcostsK117+lasercostK119),
COSTTOMAKE COMPUTED BY ((totalK121*100)/(100+Markup)),
MARKUPIN COMPUTED BY (totalK121-Costtomake)

Hope this helps.

Many thanks,

Michael

Please send to ibdac*crlab*com a complete small sample that demonstrates the problem, including script to create server objects.