jSqliteDataAccess and jSqliteCursor
lazarus / 43-Android

----------------------------------------------------------------------
dseligo · 2024-06-28 22:21

Is there something like 'ParamByName('field_name').AsString' for use
where selecting/inserting/updateing?

Is it safe to use two or more sets of components on the same SQlite
database? E.g. SqliteDataAccess1 and SqliteDataAccess2 select some
data, SqliteDataAccess3 used for insert or update.

----------------------------------------------------------------------
c4p · 2024-06-29 12:33

I have only used one component to do everything, in theory as long as
you close the connection and open on another it should be OK, I guess?

You can use the below to retrieve the value from a SELECT statement,
add it to variable 'Return' and then show on screen:

Create your table first, like on Form show (OnJNIPrompt) :
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
SQLiteDataAccess1.CreateTable('CREATE TABLE IF NOT EXISTS '+ TTable
+'(_ID INTEGER PRIMARY KEY AUTOINCREMENT, COLUMN1 TEXT, COLUMN2 TEXT,
COLUMN3 TEXT);');
You can also INSERT/UPDATE using the normal syntax:

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 SQLiteDataAccess1.InsertIntoTable('INSERT INTO ' + TTable + '
(COLUMN1, COLUMN2, COLUMN3) VALUES('+quotedstr('Something') + ',' +
quotedstr('Something') + ',' + quotedstr('Something') + ';)');
Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i
 SQLiteDataAccess1.UpdateTable('UPDATE ' + TTable + ' SET COLUMN2=' +
quotedstr('Something') + ' WHERE COLUMN1 = '+quotedstr('Something') +
';');
Add some code to run a SELECT statement and return a specific value,
obviously, be more specific about what you want to return.

Code: Pascal  [Select][+][-]window.onload = function(){var x1 =
document.getElementById("main_content_section"); if (x1) { var x =
document.getElementsByClassName("geshi");for (var i = 0; i procedure
TForm.Button1Click(Sender: TObject); var  Return : string;  begin 
 SQLiteDataAccess1.OpenOrCreate;   SQLiteDataAccess1.select('SELECT *
FROM ' + TTable);   Return :=
SQLiteDataAccess1.GetValueAsString('COLUMN1');   showmessage(Return); 
 SQLiteDataAccess1.Close;  end; 
Check out the lazandroidmodulewizard > demos > GUI > AppSqliteDemox
demos for more info.
I hope this helps.