L
Laura Stern
Guest
You just need to reopen the query. PLEASE do not set the handle property of the BindingSource to unknown and reset. That should never be necessary and is a big waste of time. It will refresh its schema and everything else that has not actually changed. The BindingSource works off of a query result set. If the query is not reopened, the record count may be wrong, which is critical for the grid to work correctly, and at least for the records that you've already scanned through it would be trying to read that original set, not anything related to the new records. And if the AutoSync property of the BindingSource is true, which it is by default, you don't even have to call the Refresh method. The query open will take care of it.
Continue reading...
Continue reading...