Sorry your browser is not supported!

Current Version 0.9i (29/03/2014)

5 more functions to increase functionality (126 functions in total now).

Easier functions to change string, integer or float cell within a table.

Function to show number of rows affected by an updating SQL statement.

Version 0.9h (17/03/2014)

Functions reading integers (and possibly strings) from SQL recordsets were skewed.  Trying to fix.

Version 0.9g (15/03/2014)

String return functions in SQLITE plugin now FIXED! 

I therefore award myself - much [ic:beer] and go to bed, early.

Some name changes for functions returning strings - beware!

Also, nb SQLITE Array functions have columns starting at 1, not 0 as with other non-Array functions...

Version 0.9f  (10/03/2014)

Trying to fix recurring faults with functions returning strings.  Fingers crossed!

Version 0.9e  (09/03/2014)

A failed version really - trying to fix recurring faults with functions returning strings...

Version 0.9d (17/02/2014)

Well, SQLITE GET TABLE NAME$ and SQLITE TABLE COUNT better work now!

Also, I've added 18 new functions/commands allowing you to create a unique SQLITE 'Array' from either a Table OR a SQL query Recordset, interrogate that Array, create a new Table from it or even export it as a simple CSV file.  Thought that would come in handy.  ;)

Version 0.9c (14/02/2014)

A little work and further improvement (hopefully) on SQLITE GET TABLE NAME$ and SQLITE TABLE COUNT...

Version 0.9b (09/02/2014)

A little work and improvement (hopefully) on SQLITE GET TABLE NAME$ and SQLITE TABLE COUNT...

Version 0.9a (09/02/2014)

Think I've sorted the the SQLITE MAKE TABLE FROM SQL QUERY RECORDS problem and I think I've sorted (but haven't tested) the SQLITE TABLE AS PRINTSTRING$ and the RECORDSET equivalent.

Version 0.9 (08/02/2014)

Thanks to Lukas W spotted (and hopefully fixed) a school boy error with functions/commands with optional parameters/flags...

Version 0.8 (14/12/2013)

Some tweaking to import and export csv commands

Additional command to list all tables in a Database as a fieldstring.

Version 0.7 (07/12/2013) - 

I've added yet a further 7 new commands/functions over v0.6.

Even though you cannot normally use SQLITE3 to drop/delete columns or insert columns, whilst retaining types/definitions, contraints etc, I've added in that functionality.  By tinkering around with writable schema pragma and sqlite_master, you have functions which allow you to get/reset/change the name, type/definition, primary key status, and foreign key attributes of any column.

For v0.7 I have added support for import from and export to csv with tables.  I have also allowed for export/import retaining all table attributes including column types, definitions, constraints, foreign keys, indices, triggers and views.  Import/Export commands will not work with tables containing 'blobs'.  I am still working on functions/commands to support 'blobs' - I think the best I will be able to do is provide support for files - so you could store a graphics file or sound file as a blob column with a blob size column then as an integer, something like that.

Anyway, the import/export commands are still thoroughly untested.

I've also added some more Index/indices functionality.

I've also added a search within recordset type command.

I've also added some 'printstring' commands so you can generate a multi line string with your recordset results (for particular rows if you want) or your table - again, thoroughly untested...

Command Set:-
   
SQLITE OPEN DATABASE                           -  a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
SQLITE CLOSE DATABASE                          -  a function returning an INTEGER value from (DatabaseID INTEGER,[ flagVacuumTheDatabase INTEGER])
SQLITE SAVE DATABASE                           -  a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFileName STRING, Username STRING, Password STRING)
SQLITE VACUUM DATABASE                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE DATABASE EXIST                          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE CURRENT DATABASE                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GET LAST ERROR$                         -  a function returning a STRING value from <*no parameters*>
SQLITE SET FOREIGN KEY CONSTRAINTS ON          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE SET FOREIGN KEY CONSTRAINTS OFF         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE ARE FOREIGN KEY CONSTRAINTS ON          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE TABLE EXIST                             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE COUNT                             -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GET TABLES FIELDSTRING$                 -  a function returning a STRING value from (DatabaseID INTEGER)
SQLITE GET TABLE NAME$                         -  a function returning a STRING value from (DatabaseID INTEGER, NumberOfTableUpToTableCount INTEGER)
SQLITE GET TABLE CREATION SQL$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING)
SQLITE TRUNCATE TABLE                          -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE EMPTY TABLE                             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE DROP TABLE                              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE DELETE TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE CREATE TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnsDefinitionsAndConstraints STRING)
SQLITE RENAME TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, OriginalTableName STRING, NewTableName STRING)
SQLITE COPY TABLE                              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, NewTableName STRING)
SQLITE EXPORT TABLE AS CSV                     -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, CSVFileName STRING,[ DetailFlag INTEGER])
SQLITE IMPORT TABLE FROM CSV                   -  a function returning an INTEGER value from (DatabaseID INTEGER, CSVFileName STRING, NewTableName STRING,[ WithForeignKeysFlag INTEGER])
SQLITE TABLE ROW COUNT                         -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE NAMED COLUMN EXIST                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE DROP NAMED COLUMN                       -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE DELETE NAMED COLUMN                     -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE RENAME COLUMN IN TABLE                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, NewColumnName STRING)
SQLITE INSERT COLUMN INTO TABLE                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, BeforeOrAfter INTEGER, InsertionIndex INTEGER, ColumnType STRING, PrimaryKeyFlag INTEGER, NotNullFlag INTEGER, DefaultValue STRING)
SQLITE INSERT COLUMN AT TABLE START            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, ColumnType STRING, PrimaryKeyFlag INTEGER, NotNullFlag INTEGER, DefaultValue STRING)
SQLITE INSERT COLUMN AT TABLE END              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, ColumnType STRING, PrimaryKeyFlag INTEGER, NotNullFlag INTEGER, DefaultValue STRING)
SQLITE ADD COLUMN TO TABLE                     -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnDefinitionAndConstraint STRING)
SQLITE TABLE COLUMN NAME$                      -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
SQLITE TABLE COLUMN INDEX                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE TABLE COLUMN DEFINITION$                -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
SQLITE TABLE COLUMN SIZE                       -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
SQLITE TABLE COLUMN COUNT                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE PRIMARY KEY COUNT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE FOREIGN KEY COUNT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE SET NAMED COLUMN TYPE                   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, NewType STRING)
SQLITE IS NAMED COLUMN PRIMARY KEY             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET NAMED COLUMN PRIMARY KEY            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OnOff INTEGER)
SQLITE GET NAMED COLUMN NOTNULL                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET NAMED COLUMN NOTNULL                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OnOff INTEGER)
SQLITE GET NAMED COLUMN DEFAULT VALUE EXIST    -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET NAMED COLUMN DEFAULT VALUE$         -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET NAMED COLUMN DEFAULT VALUE          -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, NewDefaultValue STRING)
SQLITE DOES NAMED COLUMN HAVE FOREIGN KEY      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET NAMED COLUMN FK TABLE$              -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET NAMED COLUMN FK COLUMN$             -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE REMOVE FK FROM NAMED COLUMN             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET FK ON NAMED COLUMN                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, ForeignTableName STRING, ForeignTableColumnName STRING)
SQLITE TABLE AS PRINTSTRING$                   -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, RightSetColumnLength INTEGER,[ FirstRow INTEGER,[ EndRow INTEGER])
SQLITE TABLE CREATE FIELDSTRING OF COLUMNS$    -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING,[ DelimeterForFieldString STRING])
SQLITE TABLE CELL STRING$                      -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE TABLE CELL INTEGER                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE TABLE CELL FLOAT                        -  a function returning a FLOAT value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE CHANGE TABLE CELL STRING                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OriginalCellString STRING, NewCellString STRING,[ WhereAnotherColumnNamed STRING,[ HasAStringValueOf STRING])
SQLITE CHANGE TABLE CELL INTEGER               -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OriginalCellInteger INTEGER, NewCellInteger INTEGER,[ WhereAnotherColumnNamed STRING,[ HasAnIntegerValueOf INTEGER])
SQLITE CHANGE TABLE CELL FLOAT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OriginalCellFloat FLOAT, NewCellFloat FLOAT,[ WhereAnotherColumnNamed STRING,[ HasAFloatValueOf FLOAT])
SQLITE FIND TABLE STRING$                      -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
SQLITE FIND TABLE INTEGER                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
SQLITE FIND TABLE FLOAT                        -  a function returning a FLOAT value from (OldString INTEGER, DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING,[ HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
SQLITE BEGIN SQL QUERY                         -  a function returning an INTEGER value from (DatabaseID INTEGER, SQLQuery STRING)
SQLITE BEGIN SQL QUERY SQLITEMASTER            -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY TABLELIST               -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY DATABASE INDEXLIST      -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY PRAGMA TABLEINFO        -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY PRAGMA INDEXLIST        -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY PRAGMA INDEXINFO        -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
SQLITE BEGIN SQL QUERY PRAGMA FOREIGNKEYLIST   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY SPECIFIC                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName1 STRING, ColumnValue1 STRING,[ ColumnName2 STRING,[ ColumnValue2 STRING,[ ColumnName3 STRING,[ ColumnValue3 STRING])
SQLITE FURTHER SQL QUERY                       -  a function returning an INTEGER value from (DatabaseID INTEGER, AdditionalSQLQuery STRING)
SQLITE MAKE TABLE FROM SQL QUERY RECORDS       -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName STRING)
SQLITE QUERY RECORDS COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE QUERY COLUMNS COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE QUERY COLUMN NAME$                      -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE FIRST RECORD ROW                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE PREVIOUS RECORD ROW                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE NEXT RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GOTO RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER, RowToGoTo INTEGER)
SQLITE GOTO RECORD ROW WHERE                   -  a function returning an INTEGER value from (DatabaseID INTEGER, WhereColumnNameA STRING, EqualsValueA STRING)
SQLITE LAST RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD COLUMN NAME$                     -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD COLUMN COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD ROW COUNT                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD ROW STRING$                      -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORDSET AS PRINTSTRING$               -  a function returning a STRING value from (DatabaseID INTEGER, RightSetColumnLength INTEGER,[ FirstRow INTEGER,[ EndRow INTEGER])
SQLITE RECORD CURRENT ROW FIELDSTRING$         -  a function returning a STRING value from (DatabaseID INTEGER,[ DelimeterForFieldString STRING])
SQLITE RECORD ROW INTEGER                      -  a function returning an INTEGER value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD ROW FLOAT                        -  a function returning a FLOAT value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE FINISH SQL QUERY                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE UPDATING SQL STATEMENT                  -  a function returning an INTEGER value from (DatabaseID INTEGER, UpdatingSQLStatement STRING)
SQLITE ROWS AFFECTED BY UPDATE                 -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE SET COLUMN VALUE WHERE                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnToBeEffected STRING, NewValue STRING, WhereColumnA STRING, EqualsValueA STRING,[ AndWhereColumnB STRING,[ EqualsValueB STRING])
SQLITE BEGIN TRANSACTION                       -  a function returning an INTEGER value from <*no parameters*>
SQLITE ADD TO TRANSACTION                      -  a function returning an INTEGER value from (SQLStatementToAddToTransaction STRING)
SQLITE GET CURRENT TRANSACTION STRING$         -  a function returning a STRING value from <*no parameters*>
SQLITE COMMIT TRANSACTION                      -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE INSERT ROW INTO TABLE                   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, SpecifiedNamedColumns STRING, SpecifiedValuesForThoseColumns STRING)
SQLITE DELETE ROWS FROM TABLE                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, WhereConditions STRING)
SQLITE CREATE INDEX                            -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING, TableName STRING, ColumnName STRING)
SQLITE INDEX EXIST                             -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING, TableName STRING)
SQLITE GET INDEX OF COLUMN$                    -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET INDEX CREATION SQL$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, IndexName STRING)
SQLITE DROP INDEX                              -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
SQLITE DELETE INDEX                            -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
SQLITE MAKE ARRAY FROM TABLE                   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE MAKE ARRAY FROM RECORDSET               -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE ARRAY EXIST                             -  a function returning an INTEGER value from <*no parameters*>
SQLITE ARRAY COLUMN COUNT                      -  a function returning an INTEGER value from <*no parameters*>
SQLITE ARRAY ROW COUNT                         -  a function returning an INTEGER value from <*no parameters*>
SQLITE ARRAY GET COLUMN NAME$                  -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE ARRAY GET COLUMN TYPE$                  -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE ARRAY GET COLUMN NAME WITH TYPE$        -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE ARRAY COLUMN NAMES FIELDSTRING$         -  a function returning a STRING value from <*no parameters*>
SQLITE ARRAY COLUMN TYPES FIELDSTRING$         -  a function returning a STRING value from <*no parameters*>
SQLITE ARRAY COLUMN NAMES AND TYPES FIELDSTRING-  a function returning a STRING value from <*no parameters*>
SQLITE ARRAY STRING$                           -  a function returning a STRING value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE ARRAY INTEGER                           -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE ARRAY FLOAT                             -  a function returning a FLOAT value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE MAKE TABLE FROM ARRAY                   -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName STRING,[ NumberedColumnAsPrimaryKey INTEGER,[ NamesColumnsToBeIndexed STRING])
SQLITE EXPORT SQLITE ARRAY AS CSV              -  a function returning an INTEGER value from (CSVFileName STRING)
SQLITE CLEAR SQLITE ARRAY                      -  a command with <*no parameters*>
SQLITE DELETE SQLITE ARRAY                     -  a command with <*no parameters*>
    
Total Number of Commands = 126

SELECT name FROM OpenFPS_LocationDB WHERE (start_value <= <value>) AND (end_value >= <value>)

query$ = "SELECT name FROM OpenFPS_LocationDB WHERE (start_value <= "+Geolocation_IPID+") AND (end_value >= "+Geolocation_IPID+")"
null = DSQLITE BEGIN SQL QUERY(1,query$)
null = DSQLITE FIRST RECORD ROW(1)
value$=DSQLITE GET RECORD CURRENT ROW STRING$(1,1)
null = DSQLITE FINISH SQL QUERY(1)

(24) My WHERE clause expression column1="column1" does not work. It causes every row of the table to be returned, not just the rows where column1 has the value "column1".

    Use single-quotes, not double-quotes, around string literals in SQL. This is what the SQL standard requires. Your WHERE clause expression should read: column1='column2'

    SQL uses double-quotes around identifiers (column or table names) that contains special characters or which are keywords. So double-quotes are a way of escaping identifier names. Hence, when you say column1="column1" that is equivalent to column1=column1 which is obviously always true.

Command Set:-
   
SQLITE OPEN DATABASE                           -  a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
SQLITE CLOSE DATABASE                          -  a function returning an INTEGER value from (DatabaseID INTEGER,[ flagVacuumTheDatabase INTEGER])
SQLITE SAVE DATABASE                           -  a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFileName STRING, Username STRING, Password STRING)
SQLITE VACUUM DATABASE                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE DATABASE EXIST                          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GET LAST ERROR$                         -  a function returning a STRING value from <*no parameters*>
SQLITE SET FOREIGN KEY CONSTRAINTS ON          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE SET FOREIGN KEY CONSTRAINTS OFF         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE ARE FOREIGN KEY CONSTRAINTS ON          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE TABLE EXIST                             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE COUNT                             -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GET TABLE NAME$                         -  a function returning a STRING value from (DatabaseID INTEGER, NumberOfTableUpToTableCount INTEGER)
SQLITE GET TABLE CREATION SQL$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING)
SQLITE TRUNCATE TABLE                          -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE EMPTY TABLE                             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE DROP TABLE                              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE DELETE TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE CREATE TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnsDefinitionsAndConstraints STRING)
SQLITE RENAME TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, OriginalTableName STRING, NewTableName STRING)
SQLITE COPY TABLE                              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, NewTableName STRING)
SQLITE TABLE ROW COUNT                         -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE NAMED COLUMN EXIST                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE DROP NAMED COLUMN                       -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE DELETE NAMED COLUMN                     -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE RENAME COLUMN IN TABLE                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, NewColumnName STRING)
SQLITE INSERT COLUMN INTO TABLE                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, BeforeOrAfter INTEGER, InsertionIndex INTEGER, ColumnType STRING, PrimaryKeyFlag INTEGER, NotNullFlag INTEGER, DefaultValue STRING)
SQLITE INSERT COLUMN AT TABLE START            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, ColumnType STRING, PrimaryKeyFlag INTEGER, NotNullFlag INTEGER, DefaultValue STRING)
SQLITE INSERT COLUMN AT TABLE END              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, ColumnType STRING, PrimaryKeyFlag INTEGER, NotNullFlag INTEGER, DefaultValue STRING)
SQLITE ADD COLUMN TO TABLE                     -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnDefinitionAndConstraint STRING)
SQLITE TABLE COLUMN NAME$                      -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
SQLITE TABLE COLUMN INDEX                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE TABLE COLUMN DEFINITION$                -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
SQLITE TABLE COLUMN SIZE                       -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
SQLITE TABLE COLUMN COUNT                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE PRIMARY KEY COUNT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE FOREIGN KEY COUNT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE SET NAMED COLUMN TYPE                   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, NewType STRING)
SQLITE IS NAMED COLUMN PRIMARY KEY             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET NAMED COLUMN PRIMARY KEY            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OnOff INTEGER)
SQLITE GET NAMED COLUMN NOTNULL                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET NAMED COLUMN NOTNULL                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, OnOff INTEGER)
SQLITE GET NAMED COLUMN DEFAULT VALUE EXIST    -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET NAMED COLUMN DEFAULT VALUE$         -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET NAMED COLUMN DEFAULT VALUE          -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, NewDefaultValue STRING)
SQLITE DOES NAMED COLUMN HAVE FOREIGN KEY      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET NAMED COLUMN FK TABLE$              -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE GET NAMED COLUMN FK COLUMN$             -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE REMOVE FK FROM NAMED COLUMN             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE SET FK ON NAMED COLUMN                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING, ForeignTableName STRING, ForeignTableColumnName STRING)
SQLITE TABLE CREATE FIELDSTRING OF COLUMNS$    -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING,[ DelimeterForFieldString STRING])
SQLITE TABLE CELL STRING$                      -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE TABLE CELL INTEGER                      -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE TABLE CELL FLOAT                        -  a function returning a FLOAT value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE FIND TABLE CELL STRING$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
SQLITE FIND TABLE CELL INTEGER                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
SQLITE FIND TABLE CELL FLOAT                   -  a function returning a FLOAT value from (OldString INTEGER, DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING,[ HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
SQLITE BEGIN SQL QUERY                         -  a function returning an INTEGER value from (DatabaseID INTEGER, SQLQuery STRING)
SQLITE BEGIN SQL QUERY SQLITEMASTER            -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY TABLELIST               -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY DATABASE INDEXLIST      -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY PRAGMA TABLEINFO        -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY PRAGMA INDEXLIST        -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY PRAGMA INDEXINFO        -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
SQLITE BEGIN SQL QUERY PRAGMA FOREIGNKEYLIST   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY SPECIFIC                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName1 STRING, ColumnValue1 STRING,[ ColumnName2 STRING,[ ColumnValue2 STRING,[ ColumnName3 STRING,[ ColumnValue3 STRING])
SQLITE FURTHER SQL QUERY                       -  a function returning an INTEGER value from (DatabaseID INTEGER, AdditionalSQLQuery STRING)
SQLITE MAKE TABLE FROM SQL QUERY RECORDS       -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName INTEGER)
SQLITE QUERY RECORDS COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE QUERY COLUMNS COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE QUERY COLUMN NAME$                      -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE FIRST RECORD ROW                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE PREVIOUS RECORD ROW                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE NEXT RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GOTO RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER, RowToGoTo INTEGER)
SQLITE LAST RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD COLUMN NAME$                     -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD COLUMN COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD ROW COUNT                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD CURRENT ROW STRING$              -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD CURRENT ROW FIELDSTRING$         -  a function returning a STRING value from (DatabaseID INTEGER,[ DelimeterForFieldString STRING])
SQLITE RECORD CURRENT ROW INTEGER              -  a function returning an INTEGER value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD CURRENT ROW FLOAT                -  a function returning a FLOAT value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE FINISH SQL QUERY                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE UPDATING SQL STATEMENT                  -  a function returning an INTEGER value from (DatabaseID INTEGER, UpdatingSQLStatement STRING)
SQLITE SET COLUMN VALUE WHERE                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnToBeEffected STRING, NewValue STRING, WhereColumnA STRING, EqualsValueA STRING,[ AndWhereColumnB STRING,[ EqualsValueB STRING])
SQLITE BEGIN TRANSACTION                       -  a function returning an INTEGER value from <*no parameters*>
SQLITE ADD TO TRANSACTION                      -  a function returning an INTEGER value from (SQLStatementToAddToTransaction STRING)
SQLITE GET CURRENT TRANSACTION STRING$         -  a function returning a STRING value from <*no parameters*>
SQLITE COMMIT TRANSACTION                      -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE INSERT ROW INTO TABLE                   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, SpecifiedNamedColumns STRING, SpecifiedValuesForThoseColumns STRING)
SQLITE DELETE ROWS FROM TABLE                  -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, WhereConditions STRING)
SQLITE CREATE INDEX                            -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING, TableName STRING, ColumnName STRING)
SQLITE GET INDEX CREATION SQL$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, IndexName STRING)
SQLITE DROP INDEX                              -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
SQLITE DELETE INDEX                            -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
    
Total Number of Commands = 95

SQLITE OPEN DATABASE                           -  a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
SQLITE CLOSE DATABASE                          -  a function returning an INTEGER value from (DatabaseID INTEGER,[ flagVacuumTheDatabase INTEGER])
SQLITE SAVE DATABASE                           -  a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFileName STRING, Username STRING, Password STRING)
SQLITE VACUUM DATABASE                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE DATABASE EXIST                          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GET LAST ERROR$                         -  a function returning a STRING value from <*no parameters*>

SQLITE GET LAST ERROR$                         -  a function returning a STRING value from <*no parameters*>
SQLITE SET FOREIGN KEY CONSTRAINTS ON          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE SET FOREIGN KEY CONSTRAINTS OFF         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE ARE FOREIGN KEY CONSTRAINTS ON          -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE TABLE EXIST                             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE COUNT                             -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GET TABLE NAME$                         -  a function returning a STRING value from (DatabaseID INTEGER, NumberOfTableUpToTableCount INTEGER)
SQLITE GET TABLE CREATION SQL$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING)
SQLITE TRUNCATE TABLE                          -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE EMPTY TABLE                             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE DROP TABLE                              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE DELETE TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE CREATE TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnsDefinitionsAndConstraints STRING)
SQLITE RENAME TABLE                            -  a function returning an INTEGER value from (DatabaseID INTEGER, OriginalTableName STRING, NewTableName STRING)

SQLITE BEGIN SQL QUERY                         -  a function returning an INTEGER value from (DatabaseID INTEGER, SQLQuery STRING)
SQLITE BEGIN SQL QUERY SQLITEMASTER            -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY TABLELIST               -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY DATABASE INDEXLIST      -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE BEGIN SQL QUERY PRAGMA TABLEINFO        -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY PRAGMA INDEXLIST        -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY PRAGMA INDEXINFO        -  a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
SQLITE BEGIN SQL QUERY PRAGMA FOREIGNKEYLIST   -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE BEGIN SQL QUERY SPECIFIC                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName1 STRING, ColumnValue1 STRING,[ Colu

SQLITE FIRST RECORD ROW                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE PREVIOUS RECORD ROW                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE NEXT RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE GOTO RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER, RowToGoTo INTEGER)
SQLITE LAST RECORD ROW                         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD COLUMN NAME$                     -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD COLUMN COUNT                     -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD ROW COUNT                        -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE RECORD CURRENT ROW STRING$              -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD CURRENT ROW FIELDSTRING$         -  a function returning a STRING value from (DatabaseID INTEGER,[ DelimeterForFieldString STRING])
SQLITE RECORD CURRENT ROW INTEGER              -  a function returning an INTEGER value from (DatabaseID INTEGER, ColumnNumber INTEGER)
SQLITE RECORD CURRENT ROW FLOAT                -  a function returning a FLOAT value from (DatabaseID INTEGER, ColumnNumber INTEGER)

SQLITE FINISH SQL QUERY                        -  a function returning an INTEGER value from (DatabaseID INTEGER)

SQLITE UPDATING SQL STATEMENT                  -  a function returning an INTEGER value from (DatabaseID INTEGER, UpdatingSQLStatement STRING)

Rem LW - Open (or create) "test" database
result = SQLITE Open Database( 1, "test.s3db", "", "" )

Rem LW - Purge database
If SQLITE Table Exist( 1, "mytable1" ) Then result = SQLITE Drop Table( 1, "mytable1" )
If SQLITE Table Exist( 1, "mytable2" ) Then result = SQLITE Drop Table( 1, "mytable2" )

Rem LW - Make new table

	// does not work
query$ = ""
query$ = query$ + "CREATE TABLE mytable1("
query$ = query$ + "[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "
query$ = query$ + "[Name] VARCHAR(20)"
query$ = query$ + ")"
result = SQLITE Begin SQL Query( 1, query$ )
result = SQLITE Finish SQL Query( 1 )
print query$

	// works
column$ = "[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(20)"
result2 = SQLITE Create Table( 1, "mytable2", column$ )
Print SQLITE Get Table Creation SQL$(1,"mytable2")

Print
print result
print result2

wait key
END

Rem LW - Open (or create) "test" database
result = SQLITE Open Database( 1, "test.s3db", "", "" )

Rem LW - Purge database
If SQLITE Table Exist( 1, "mytable1" ) Then result = SQLITE Drop Table( 1, "mytable1" )
If SQLITE Table Exist( 1, "mytable2" ) Then result = SQLITE Drop Table( 1, "mytable2" )

Rem LW - Make new table

	// works
query$ = ""
query$ = query$ + "CREATE TABLE mytable1("
query$ = query$ + "[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, "
query$ = query$ + "[Name] VARCHAR(20)"
query$ = query$ + ")"
result = SQLITE Updating SQL Statement( 1, query$ )
print query$

	// still works
column$ = "[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(20)"
result2 = SQLITE Create Table( 1, "mytable2", column$ )
Print SQLITE Get Table Creation SQL$(1,"mytable2")

Print
print result
print result2

wait key
END

<?php
// insert to table
$sql = "INSERT INTO `test`.`mytable` SET `Name`='$name'";
$result = mysql_query($sql);

// get id of new row
$sql = "SELECT * FROM `mytable` ORDER BY `ID` ASC";
$result = mysql_query($sql);
    while($row = mysql_fetch_array($result)){
        if($row['Name']==$name){
             $id = $row['ID'];
        }
    }
    
// update row with description
$sql = "UPDATE `test`.`mytable` SET `Description`='$desc' WHERE `ID`='$id'";
$result = mysql_query($sql);

// output
$sql = "SELECT * FROM `mytable` ORDER BY `ID` ASC"; $result = mysql_query($sql);
    while($row = mysql_fetch_array($result)){
        $name = $row['Name'];
        $desc = $row['Description'];
        
        echo( "Name:$name   Desc:$desc" );
    }
?>

Rem LW - Open (or create) "test" database
result = SQLITE Open Database( 1, "test.s3db", "", "" )

Rem LW - Purge database
If SQLITE Table Exist( 1, "mytable" ) Then result = SQLITE Drop Table( 1, "mytable" )

Rem LW - Make new table
column$ = "[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(20), [Description] VARCHAR(50)"
result = SQLITE Create Table( 1, "mytable", column$ )


Rem LW - set data
name$ = "my row"
desc$ = "my description"

Rem LW - add new row
sql$ = "INSERT INTO mytable (Name) VALUES ('"+name$+"');"
result = SQLITE Updating SQL Statement( 1, sql$ )

Rem LW - get ID of new created row
rows = SQLITE Table Row Count( 1, "mytable" )
For row = 1 To rows
    If SQLITE Table Cell String$( 1, "mytable", 1, row ) = name$
        row_id = SQLITE Table Cell Integer( 1, "mytable", 0, row )
    EndIf
Next row

Rem LW - update row with description
sql$ = "UPDATE mytable SET Description='"+desc$+"' WHERE ID="+str$(row_id)+";"
result = SQLITE Updating SQL Statement( 1, sql$ )


Rem LW - output
row = SQLITE Table Row Count( 1, "mytable" )
For x = 1 To row
    name$ = SQLITE Table Cell String$( 1, "mytable", 1, x )
    desc$ = SQLITE Table Cell String$( 1, "mytable", 2, x )
    Print "Name:", name$, "  Desc:", desc$
Next x

wait key
END

Rem LW - Open (or create) "test" database
result = SQLITE Open Database( 1, "test.s3db", "", "" )

Rem LW - Purge database
If SQLITE Table Exist( 1, "mytable" ) Then result = SQLITE Drop Table( 1, "mytable" )



Rem LW - Make new table
column$ = "[ID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, [Name] VARCHAR(20), [Group] VARCHAR(50)"
result = SQLITE Create Table( 1, "mytable", column$ )

Rem LW - set data
name$ = "my row"
grou$ = "my group"

Rem LW - add new row
sql$ = "INSERT INTO mytable (Name) VALUES ('"+name$+"');"
result = SQLITE Updating SQL Statement( 1, sql$ )

Rem LW - get ID of new created row
rows = SQLITE Table Row Count( 1, "mytable" )
For row = 1 To rows
    If SQLITE Table Cell String$( 1, "mytable", 1, row ) = name$ : row_id = SQLITE Table Cell Integer( 1, "mytable", 0, row ) : EndIf
Next row

Rem LW - update row
result = SQLITE SET COLUMN VALUE WHERE( 1, "mytable", "Group", "'"+grou$+"'", "ID", str$(row_id) )

Rem LW - output
rows = SQLITE Table Row Count( 1, "mytable" )
For row = 1 To rows
    name$ = SQLITE Table Cell String$( 1, "mytable", 1, row )
    desc$ = SQLITE Table Cell String$( 1, "mytable", 2, row )
    Print "Name:", name$, "  Group:", desc$
Next row

wait key
END

sql$ = "SELECT * FROM mytable;"
n = Sqlite Begin Sql Query( 1, sql$ )
rows = Sqlite Record Row Count( 1 )
For row = 1 To rows
	id = Sqlite Record Current Row Integer( 1, 0 )
	a$ = Sqlite Record Current Row String$( 1, 1 )
  n = Sqlite Next Record Row( 1 )
Next row

Sync On
time = Timer()
time = Timer()

Rem LW - Open (or create) "test" database
result = SQLITE Open Database( 1, "test.s3db", "", "" )

Rem LW - Purge database
If SQLITE Table Exist( 1, "mytable" ) Then result = SQLITE Drop Table( 1, "mytable" )
Print "start : ", (timer()-time), "ms" : time = timer()


Rem LW - Make new table
PRint "create table : "; : sync
    column$ = "[ID] INTEGER PRIMARY KEY ASC, "
    column$ = column$ + "[A] VARCHAR(20), "
    column$ = column$ + "[B] VARCHAR(20), "
    column$ = column$ + "[C] VARCHAR(20), "
    column$ = column$ + "[D] INTEGER, "
    column$ = column$ + "[E] INTEGER, "
    column$ = column$ + "[F] INTEGER, "
    column$ = column$ + "[G] VARCHAR(20), "
    column$ = column$ + "[H] INTEGER, "
    column$ = column$ + "[I] INTEGER, "
    column$ = column$ + "[J] INTEGER, "
    column$ = column$ + "[K] VARCHAR(20), "
    column$ = column$ + "[L] INTEGER, "
    column$ = column$ + "[M] VARCHAR(20), "
    column$ = column$ + "[N] VARCHAR(20), "
    column$ = column$ + "[O] INTEGER, "
    column$ = column$ + "[P] INTEGER, "
    column$ = column$ + "[Q] INTEGER"
    result = SQLITE Create Table( 1, "mytable", column$ )
Print (timer()-time), "ms" : time = timer()



Rem LW - Add 10 rows using command
Print "fill table(command): "; : sync
    For x = 1 To 10
        columns$ = "A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q"
        values$ = "'a','b','c',1,2,3,'a',1,2,3,'a',1,'a','b',1,2,3"
        result = Sqlite Insert Row Into Table( 1, "mytable", columns$, values$ )
    next x
Print (timer()-time), "ms" : time = timer()


Rem LW - Add 10 more rows using transaction
Print "fill table(trans.): "; : sync
    result = sqlite begin transaction()
    For x = 1 To 10
        columns$ = "A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q"
        values$ = "'a','b','c',1,2,3,'a',1,2,3,'a',1,'a','b',1,2,3"
        sql$ = "INSERT INTO mytable ("+columns$+") VALUES ("+values$+")"
        result = Sqlite Add To Transaction( sql$ )
    next x
    result = Sqlite Commit Transaction( 1 )
Print (timer()-time), "ms" : time = timer()


Rem LW - Retrieve using command
Print "retrieve(command) : "; : sync
    rows = SQLITE Table Row Count( 1, "mytable" )
    For row = 1 To rows
    	id= Sqlite Table Cell Integer( 1, "mytable", 0, row )
    	a$= SQLITE Table Cell String$( 1, "mytable", 1, row )
    	b$= SQLITE Table Cell String$( 1, "mytable", 2, row )
    	c$= SQLITE Table Cell String$( 1, "mytable", 3, row )
    	d = Sqlite Table Cell Integer( 1, "mytable", 4, row )
    	e = Sqlite Table Cell Integer( 1, "mytable", 5, row )
    	f = Sqlite Table Cell Integer( 1, "mytable", 6, row )
    	g$= SQLITE Table Cell String$( 1, "mytable", 7, row )
    	h = Sqlite Table Cell Integer( 1, "mytable", 8, row )
    	i = Sqlite Table Cell Integer( 1, "mytable", 9, row )
    	j = Sqlite Table Cell Integer( 1, "mytable",10, row )
    	k$= SQLITE Table Cell String$( 1, "mytable",11, row )
    	l = Sqlite Table Cell Integer( 1, "mytable",12, row )
    	m$= SQLITE Table Cell String$( 1, "mytable",13, row )
    	n$= SQLITE Table Cell String$( 1, "mytable",14, row )
    	o = Sqlite Table Cell Integer( 1, "mytable",15, row )
    	p = Sqlite Table Cell Integer( 1, "mytable",16, row )
    	q = Sqlite Table Cell Integer( 1, "mytable",17, row )
    Next row
Print (timer()-time), "ms" : time = timer()


Rem LW - Retrieve using recordset
Print "retrieve(record) : "; : sync
    sql$ = "SELECT * FROM mytable;"
    n = Sqlite Begin Sql Query( 1, sql$ )
    rows = Sqlite Record Row Count( 1 )
    For row = 1 To rows
    	id= Sqlite Record Current Row Integer( 1, 0 )
    	a$= Sqlite Record Current Row String$( 1, 1 )
    	b$= Sqlite Record Current Row String$( 1, 2 )
    	c$= Sqlite Record Current Row String$( 1, 3 )
    	d = Sqlite Record Current Row Integer( 1, 4 )
    	e = Sqlite Record Current Row Integer( 1, 5 )
    	f = Sqlite Record Current Row Integer( 1, 6 )
    	g$= Sqlite Record Current Row String$( 1, 7 )
    	h = Sqlite Record Current Row Integer( 1, 8 )
    	i = Sqlite Record Current Row Integer( 1, 9 )
    	j = Sqlite Record Current Row Integer( 1, 10 )
    	k$= Sqlite Record Current Row String$( 1, 11 )
    	l = Sqlite Record Current Row Integer( 1, 12 )
    	m$= Sqlite Record Current Row String$( 1, 13 )
    	n$= Sqlite Record Current Row String$( 1, 14 )
    	o = Sqlite Record Current Row Integer( 1, 15 )
    	p = Sqlite Record Current Row Integer( 1, 16 )
    	q = Sqlite Record Current Row Integer( 1, 17 )
        n = Sqlite Next Record Row( 1 )
    Next row
    n = Sqlite Finish Sql Query(1)
Print (timer()-time), "ms"
time = timer()


Rem LW - Finish
Print
Print "done"
Sync
wait key
n = Sqlite Close Database( 1 )
END