BorlandTalk.com

Tim · Guest

Using a query/datasetprovider/clientdataset/datasource, I have a form
displaying editable information on a person, derived from a MySQL database.
One field allows the person to be designated as a manager and a
DBLookupCombo allows the selection of a manager, if applicable. The
DBLookupCombo gets it's data from a query which returns only those persons
where manager = true.

The problem is updating. In the AfterPost method of the form, I close and
open the query which supplies the dataset for the manager lookup, but
assuming I have just set a person as a manger, they are not shown in the
list. Go in later and there they are.

I can only assume that although I have put the update in the AfterPost
method, the actual changes are not available to the other dataset.

How can I make the updated record immediately available, or maybe it needs
to be done another way?

Thanks.

Bill Todd · Guest

You must call CDS.ApplyUpdates before the new row is inserted into the
database.

--
Bill Todd (TeamB)
TeamB cannot answer questions received via email

Tim · Guest

I've been working with BDE too much recently. Using AfterApplyUpdates is
where I should have put my update code. Problem solved.

Tim

Tim · Guest

"Bill Todd" <no (AT) no (DOT) com> wrote