<div>
yep, seems that a commit is missed
</div>


<div>
hmm ... <br />
<br />
what part of the code needs the commit?<br />
If I put it after execsql it won't compile.<br />
Which object needs the .commit?<br />
Or is there a commit setting on the object Im missin?
</div>


hmm ...

what part of the code needs the commit?
If I put it after execsql it won't compile.
Which object needs the .commit?
Or is there a commit setting on the object Im missin?

<div>
I thought if your query is just -<br />
<br />
update TABLE set blah blah blah<br />
<br />
- then execsql would just update the record and commit automatically (bearing in mind no cache updates)
</div>


I thought if your query is just -

update TABLE set blah blah blah

- then execsql would just update the record and commit automatically (bearing in mind no cache updates)

<div>
Got it working :)<br />
<br />
thx again ... I just need that odd poke in the right direction sometimes :)
</div>


Got it working :)

thx again ... I just need that odd poke in the right direction sometimes :)

<div>
<div class="content wysiwyg-content">
Im using interbase as my back end db.<br />
<br />
Im updating a record using a TIBQuery, setting the params and using ExecSQL command to execute it.<br />
The record seems to be updating in the grids etc I am using, but when I use another query to retrieve data fom the table Ive updated it doesnt seem to be there.<br />
If I shut the program down again and restart, the information then appears.<br />
<br />
Im not using cached updates.<br />
<br />
Whe I use the execsql, do I need to apply/commit somewhere?<br />
I cant do applydates on the dataset as it is closed (just using execsql command to update)
</div>
</div>


Im using interbase as my back end db.

Im updating a record using a TIBQuery, setting the params and using ExecSQL command to execute it.
The record seems to be updating in the grids etc I am using, but when I use another query to retrieve data fom the table Ive updated it doesnt seem to be there.
If I shut the program down again and restart, the information then appears.

Im not using cached updates.

Whe I use the execsql, do I need to apply/commit somewhere?
I cant do applydates on the dataset as it is closed (just using execsql command to update)

Am I missing a database update?

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.