<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>If data of underlaying TSQLQuery are presented and edited only
thorought this DBGrid then I would add to TSQLQuery option
"sqoAutoApplyUpdates".<br>
(I am not familiar with architecture of LazDataDesktop)<br>
Which causes that on every Post/Delete updates are applied to
database.<br>
There will remain option to commit or rollback changes.<br>
L.<br>
</p>
<div class="moz-cite-prefix">Dňa 4.9.2019 o 20:02 Ondrej Pokorny via
lazarus napísal(a):<br>
</div>
<blockquote type="cite"
cite="mid:8be786e8-1933-f65e-3b6a-1cb1f9e33939@kluug.net">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<p>Hello (Michael)!</p>
<p>I started to use LazDataDesktop because PgAdmin4 is horrible.</p>
<p>I have a problem with transactions with Postgres connection
(well I tested only Postgres connection).</p>
<p>I found out that when using the SQL editor, I can type "COMMIT"
and "ROLLBACK" - so far so good. (Well I would like to have a
tool button for these commands but OK for now - I may add them
in the future.)</p>
<p>The real problem: I cannot apply edited data from the DB grid.
I keep getting this error:</p>
<p><img src="cid:part1.6B2CD64D.4ED9EA3E@zoznam.sk" alt=""
class=""></p>
<p>I have clicked on the tick button - it got disabled. I have
also clicked on the button next to refresh - well I don't know
that the button does because it has no hint and caption, but I
clicked on it nevertheless :) :</p>
<p><img src="cid:part2.56DB9B29.7ABA74D7@zoznam.sk" alt=""
class=""></p>
<p>But still I get the error above and the data is not written.</p>
<p>How can I commit the changes made in the data grid?</p>
<p>Thanks<br>
Ondrej<br>
</p>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
</blockquote>
</body>
</html>