Recent

« previous next »
Pages: [1]

Author Topic: [Solved] SQLite: Commit changes to one table, continue dataset on another  (Read 2140 times)

bobonwhidbey

  • Hero Member
  • *****
  • Posts: 630
    • Double Dummy Solver - free download
[Solved] SQLite: Commit changes to one table, continue dataset on another
« on: November 04, 2017, 09:17:27 pm »
My SQLite database has 2 tables. How can I update and commit changes to one table, while continuing to use a dataset on the other table? 
« Last Edit: November 05, 2017, 03:13:31 am by bobonwhidbey »
Logged
Lazarus 4.6 FPC 3.2.2 x86_64-win64-win32/win64

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1225
Re: SQLite: Commit changes to one table, continue dataset on another
« Reply #1 on: November 05, 2017, 02:16:22 am »
You can use one TSQLite3Connection, two TSQLTransaction and two TSQLQuery components from the 'SQLdb tab' in the component palette.
http://wiki.freepascal.org/SQLdb_Package
http://wiki.freepascal.org/SQLite
http://wiki.freepascal.org/SQLdb_Tutorial1
Logged

bobonwhidbey

  • Hero Member
  • *****
  • Posts: 630
    • Double Dummy Solver - free download
Re: SQLite: Commit changes to one table, continue dataset on another
« Reply #2 on: November 05, 2017, 03:13:14 am »
Thank you valdir....just the knowledge I needed  :D

I was using 1 Conn, 1 Trans, and 2 Queries....which wasn't working
« Last Edit: November 05, 2017, 03:14:49 am by bobonwhidbey »
Logged
Lazarus 4.6 FPC 3.2.2 x86_64-win64-win32/win64
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018