On Thu, March 13, 2014 11:25, Reinier Olislagers wrote: > On 13/03/2014 00:06, Nathan Wild wrote:
Please note that the original poster is not subscribed to the mailing list and thus may not see your responses (like the one below) unless including him in Cc: explicitly. Unfortunately, he hasn't mentioned this fact in his post... Tomas >> 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. > Good to hear that ;) > >> 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. >> >> Am I missing something stupid? > We don't know your code, so no idea... <open door> Are you .Posting the > data? > > To give you an idea, the GUI/RAD tutorials > http://wiki.lazarus.freepascal.org/SQLdb_Tutorial0 > http://wiki.lazarus.freepascal.org/SQLdb_Tutorial1 > and > http://wiki.lazarus.freepascal.org/SQLdb_Tutorial2 > should work with odbc as well as with other dbs; just use odbcconn.. > > Also, you could have a look at the database test suite: > http://wiki.lazarus.freepascal.org/Databases#Running_FPC_database_tests > fpc\packages\fcl-db\tests\dbtestframework.pas > > The info on > http://wiki.lazarus.freepascal.org/ODBCConn > you probably already know about as you can connect etc. > Please feel free to document any hints/tips/needed additions for > Pervasive there... > > You could create a minimal test program based on > http://wiki.lazarus.freepascal.org/Database_bug_reporting#FreePascal > and post on the forum > http://forum.lazarus.freepascal.org/index.php/board,63.0.html > with an attachment. _______________________________________________ fpc-devel maillist - fpc-devel@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-devel