Recent

Author Topic: LAMW: jSqliteDataAccess  (Read 2344 times)

c4p

  • Full Member
  • ***
  • Posts: 157
LAMW: jSqliteDataAccess
« on: April 29, 2018, 10:26:33 am »
I can't seem to find an Alterdatabase method in jSqliteDataAccess, I believe there is a limited subset of ALTER TABLE supported in SQLite v3. I would say ADD COLUMN is an essential part of the jSqliteDataAccess component, not so much RENAME but would be a nice to have. Dropping and recreating a table is not so convenient.

Using this component to great effect so far, amazing how much development work has been done with LAMW :)
Lazarus 2.0.12 r64642/FPC 3.2.0 LAMW v0.8.6.4 on Windows 10+Linux Mint 21.2, projects mainly built using AppCompat and Gradle v8.5

DonAlfredo

  • Hero Member
  • *****
  • Posts: 1739
Re: LAMW: jSqliteDataAccess
« Reply #1 on: April 29, 2018, 10:55:40 am »
A sidenote:
You can also use the mORMot on Android.
https://synopse.info/fossil/wiki?name=SQLite3+Framework

c4p

  • Full Member
  • ***
  • Posts: 157
Re: LAMW: jSqliteDataAccess
« Reply #2 on: April 29, 2018, 11:09:20 am »
Thanks for the info, very useful, I will look into that framework.
Lazarus 2.0.12 r64642/FPC 3.2.0 LAMW v0.8.6.4 on Windows 10+Linux Mint 21.2, projects mainly built using AppCompat and Gradle v8.5

 

TinyPortal © 2005-2018