How can I control an TQuery behaviour after call "commit" or "rollback" from my application code? Now, when I call commit or rollbank, after this I have no data im my query -> crdbgrid.
Hi, commit and rollback close the cursor in the database, that is why you do not see any data. To be able to see data you must use commitretaining or rollbackretaining which do not close the cursor in the database and retain the data in the dataset.