<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<br>
<blockquote
cite="mid:CADRiKmoZpssQpCr_zCV9eFdQwVykGbG5xcp+EQN=TsKJxkkcow@mail.gmail.com"
type="cite">
<p dir="ltr">Nope. Is that required?</p>
</blockquote>
Yes is. TSQLQuery is descendant of "buffered dataset" so all changes
what you do are cached localy until they are applied to remote database.<br>
ApplyUpdates does it ...<br>
<br>
<blockquote
cite="mid:CADRiKmoZpssQpCr_zCV9eFdQwVykGbG5xcp+EQN=TsKJxkkcow@mail.gmail.com"
type="cite">
<p dir="ltr">How does that factor in to accessing the data through
bound controls?</p>
</blockquote>
Bound controls have nothing with it ;-)<br>
L.<br>
<br>
<blockquote
cite="mid:CADRiKmoZpssQpCr_zCV9eFdQwVykGbG5xcp+EQN=TsKJxkkcow@mail.gmail.com"
type="cite">
<p dir="ltr">Thanks.</p>
<p dir="ltr">Nathan T. Wild</p>
<div class="gmail_quote">On Mar 13, 2014 9:57 AM, "LacaK" <<a
moz-do-not-send="true" href="mailto:lacak@zoznam.sk">lacak@zoznam.sk</a>>
wrote:<br type="attribution">
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Nathan
Wild wrote / napísal(a):<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<br>
I have been transitioning my work over from Delphi to Lazarus. For the
most part it has been smooth and satisfying experience. I'm loving
Lazarus and FPC and being unburdened by closed source proprietary stuff
in general.<br>
<br>
The majority of the work I do requires connections to a Pervasive
database (from Btrieve v6 all the way up to the most current). I
should be able to do this via ODBC. I have no problem reading data,
executing queries, etc. but as soon I try and act on a TSQLQuery using
methods like .Delete(), .Append(), etc. everything appears to work
fine, but as soon as the dataset refreshes my changes disappear. I can
write to the same tables using INSERT, DELETE and UPDATE queries
without issue.<br>
</blockquote>
Do you use TSQLQuery.ApplyUpdates followed by TSQLTransaction.Commit or
CommitRetaining ?<br>
-lacak.<br>
<br>
_______________________________________________<br>
fpc-devel maillist - <a moz-do-not-send="true"
href="mailto:fpc-devel@lists.freepascal.org" target="_blank">fpc-devel@lists.freepascal.org</a><br>
<a moz-do-not-send="true"
href="http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel"
target="_blank">http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel</a><br>
</blockquote>
</div>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
fpc-devel maillist - <a class="moz-txt-link-abbreviated" href="mailto:fpc-devel@lists.freepascal.org">fpc-devel@lists.freepascal.org</a>
<a class="moz-txt-link-freetext" href="http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel">http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel</a>
</pre>
</blockquote>
<br>
</body>
</html>