Database update missing changes 1

[lespaul]

Hello all!

I have a "Search Form" with a qry and a dataset. The qry selects * from the main table and displays 5 fields in a DBGrid. When a user doubleclicks a specific record in the DBGrid, the Information Form (with DBEdits) opens. The DBEdits Datasource is the dataset from the Search Form. When I update the information form for multiple records, all but the last record get updated. If I just update ONE record, the information doesn't get updated. Any suggestions?

Thanks,
Leslie

 

[Svanhooft]

hi,

Do you use an update qry for updating the dataset? There must be a simple explantion for this. Post the code in de click on the dbgrid and the post to the database and your update qry for the dataset.

Steph [Bigglasses]

 

[McMerfy]

When you update several record at a time Post method is called everytime you move to another record. So i guess you just need to call Post method of your dataset when your editor form closes.
Hope that helps.

--- markus

 

[lespaul]

Putting the Post in did it! Thanks Markus!

Leslie Leslie
landrews@metrocourt.state.nm.us