[fpc-devel] odbcconn.pas

LacaK lacak at zoznam.sk
Fri Mar 14 13:40:28 CET 2014

> Nope.  Is that required?
Yes is. TSQLQuery is descendant of "buffered dataset" so all changes 
what you do are cached localy until they are applied to remote database.
ApplyUpdates does it ...

> How does that factor in to accessing the data through bound controls?
Bound controls have nothing with it ;-)

> Thanks.
> Nathan T. Wild
> On Mar 13, 2014 9:57 AM, "LacaK" <lacak at zoznam.sk 
> <mailto:lacak at zoznam.sk>> wrote:
>     Nathan Wild  wrote / napĂ­sal(a):
>         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.
>         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.
>     Do you use TSQLQuery.ApplyUpdates followed by
>     TSQLTransaction.Commit or CommitRetaining ?
>     -lacak.
>     _______________________________________________
>     fpc-devel maillist  -  fpc-devel at lists.freepascal.org
>     <mailto:fpc-devel at lists.freepascal.org>
>     http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel
> ------------------------------------------------------------------------
> _______________________________________________
> fpc-devel maillist  -  fpc-devel at lists.freepascal.org
> http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freepascal.org/pipermail/fpc-devel/attachments/20140314/567fa149/attachment.html>

More information about the fpc-devel mailing list