Sqlite, ODBC and a Database Manager?

Author

Message

Duffer

21

Years of Service

User Offline

Joined: 9th Feb 2003

Location: chair

Posted: 22nd Nov 2014 02:45

Link

Just to cover off the preliminaries, I've already created ODBC and Sqlite3 plugins for DBPro. So I mean business, sort of.

One shortcoming was lack of support for blobs and integration with Memblocks in my Sqlite3 and ODBC plugins for DBPro.

Sort of trying to persuade myself to put the effort in on this, so, in that vein, would there be any demand for:-

1. extension to those plugins giving support for memblocks and blobs in Sqlite and ODBC databases; and

2. a database manager application in Windows allowing you to tinker to hell with Sqlite or ODBC databases and perhaps convert in not just tables but also databases from ODBC/MS Access to Sqlite?

Or would such developments be ultimately only self-serving?

Just asking.

a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...

Back to top

Profile PM Email

Ortu

DBPro Master

16

Years of Service

User Offline

Joined: 21st Nov 2007

Location: Austin, TX

Posted: 22nd Nov 2014 04:38

Link

Hey man, I use your sqlite3 plugin regularly and blob/memblock support would be pretty awesome.

There are already quite a few database manager applications out there, I use Sqlite Browser which is pretty good and easy to use. Tackling this would probably be more for the fun of it, which isn't a bad thing.

Back to top

Profile PM Email Website

Duffer

21

Years of Service

User Offline

Joined: 9th Feb 2003

Location: chair

Posted: 22nd Nov 2014 09:06

Link

@ Ortu,

Great to know people are actually using my Sqlite plugin.

I wonder if anyone is using the latest version of my ODBC plugin and whether it actually works?

I was working on a new version of my plugin (just a few enhancements and commands for the lazy, like me) and thought, hell, why not, let's tackle the blob thing... I think I can create some commands which muck around directly with memblocks as well.

We shall see...

a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...

Back to top

Profile PM Email

mr_d

DBPro Tool Maker

17

Years of Service

User Offline

Joined: 26th Mar 2007

Location: Somewhere In Australia

Posted: 24th Nov 2014 08:15

Link

Hi Duffer, I haven't sued your plugins in any of my projects so far, but can see that they will be very useful in the future; particularly if you complete the feature set with memblocks and blob support.
Personally, I would like this only in your sqlite plugin as that would be more useful than a generic ODBC one (again for me personally). Anyway, you have my vote - keep up the good work!

Back to top

Profile PM Email

Duffer

21

Years of Service

User Offline

Joined: 9th Feb 2003

Location: chair

Posted: 24th Nov 2014 08:54

Link

@ mr_d,

Just so long as you use (rather than sue) my plugins I'm a happy chap....

To be honest, I had a crack at memblock implementation at the weekend. Managed to sort playing memblocks in to sqlite but not out of it and back in to DBPro.

Unless a miracle occurs, I am going to work with the grab a file (any file), in to a blob in sqlite, playing it back out to a file from a blob. Inellegant - but it will work.

a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...

Back to top

Profile PM Email

Rudolpho

18

Years of Service

User Offline

Joined: 28th Dec 2005

Location: Sweden

Posted: 25th Nov 2014 15:44

Link

Quote: "Just so long as you use (rather than sue) my plugins I'm a happy chap.... "

Haha, good one.

Quote: "Unless a miracle occurs, I am going to work with the grab a file (any file), in to a blob in sqlite, playing it back out to a file from a blob. Inellegant - but it will work."

You can call void ?ReturnMemblockPtrs@@YAXPAPAX0@Z(void**, void**) from your plugin. This will return pointers to two arrays; the first contains 258 DWORD's and correspond to the memblock sizes, the second contains pointers to the actual memory (data) block.
You should then be able to just memcpy the blob data - I assume you have a pointer to that available since you're able to write it to a file.

The returned arrays pointers are used directly by DBPro so you should be able to free and re-allocate memblocks of various sizes directly using those. Of course you can also read data from them.

Back to top

Profile PM Email Website

Duffer

21

Years of Service

User Offline

Joined: 9th Feb 2003

Location: chair

Posted: 30th Nov 2014 14:36 Edited at: 30th Nov 2014 17:04

Link

Here is my first attempt at a new version of my SQLITE plugin with Blob/Memblock commands. Not enough functionality there yet on Memblocks but enough to be servicable - if it works.

Consider it a pre-alpha!

Can anyone test for me please?

P.S. here is the new n improved extended command list:-

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 ADD COLUMN TO TABLE  		       -   a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnDefinitionAndConstraint 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 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 BLOB COLUMN COUNT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE BLOB COLUMN EXIST                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE TABLE BLOB COLUMN POSITION              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, NamedBlobColumn STRING)
SQLITE TABLE BLOB COLUMN NAME$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, NumberedBlobColumn INTEGER)
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, ColumnNameA INTEGER, OriginalCellString STRING, NewCellString STRING,[ WhereColumnB STRING,[ HasAStringValueOfC STRING,[ AndColumnC STRING,[ HasStringValueOfD 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 FIND TABLE BLOB MEMBLOCK                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, FindBlobInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING, AndWhereColumnnC1 INTEGER,[ HasValueC2 STRING,[ MemblockToCreateID INTEGER])
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 GET LAST SQL QUERY$                     -  a function returning a STRING value from <*no parameters*>
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 RECORD ROW BLOB MEMBLOCK                -  a function returning an INTEGER value from (DatabaseID INTEGER, ColumnNumber INTEGER, MemblockToBeCreatedID 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 LAST UPDATING SQL STATEMENT$            -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
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 SET MEMBLOCK BLOB WHERE                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, BLOBColumnToBeEffected STRING, MemblockID INTEGER, WhereColumnA STRING, EqualsValueA STRING,[ AndWhereColumnB STRING,[ EqualsValueB STRING])
SQLITE INSERT MEMBLOCK BLOB                    -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, BLOBColumnToBeEffected STRING, MemblockID INTEGER)
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 SUPERSTRING FROM TABLE             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE MAKE SUPERSTRING FROM RECORDSET         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE SUPERSTRING EXIST                       -  a function returning an INTEGER value from <*no parameters*>
SQLITE GET SUPERSTRING$                        -  a function returning a STRING value from <*no parameters*>
SQLITE CLEAR SUPERSTRING                       -  a function returning an INTEGER value from <*no parameters*>
SQLITE SUPERSTRING COLUMN COUNT                -  a function returning an INTEGER value from <*no parameters*>
SQLITE SUPERSTRING ROW COUNT                   -  a function returning an INTEGER value from <*no parameters*>
SQLITE SUPERSTRING GET COLUMN NAME$            -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE SUPERSTRING GET COLUMN TYPE$            -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE SUPERSTRING GET COLUMN NAME WITH TYPE$  -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE SUPERSTRING COLUMN NAMES FIELDSTRING$   -  a function returning a STRING value from <*no parameters*>
SQLITE SUPERSTRING COLUMN TYPES FIELDSTRING$   -  a function returning a STRING value from <*no parameters*>
SQLITE SUPERSTRING COLUMN NAMES AND TYPES FIELD-  a function returning a STRING value from <*no parameters*>
SQLITE SUPERSTRING GET STRING$                 -  a function returning a STRING value from (Column INTEGER, Row INTEGER)
SQLITE SUPERSTRING SET STRING                  -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER, NewStringValue STRING)
SQLITE SUPERSTRING GET INTEGER                 -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER)
SQLITE SUPERSTRING SET INTEGER                 -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER, NewIntegerValue INTEGER)
SQLITE SUPERSTRING GET FLOAT                   -  a function returning a FLOAT value from (Column INTEGER, Row INTEGER)
SQLITE SUPERSTRING SET FLOAT                   -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER, NewFloatValue INTEGER)
SQLITE MAKE TABLE FROM SUPERSTRING             -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName 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 SET STRING                        -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER, NewString STRING)
SQLITE ARRAY INTEGER                           -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE ARRAY SET INTEGER                       -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER, NewInteger INTEGER)
SQLITE ARRAY FLOAT                             -  a function returning a FLOAT value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE ARRAY SET FLOAT                         -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER, NewFloat INTEGER)
SQLITE MAKE TABLE FROM ARRAY                   -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName STRING,[ NumberedColumnAsPrimaryKey INTEGER,[ NamesColumnsToBeIndexed STRING])
SQLITE EXPORT 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*>

+ Code Snippet

 
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 ADD COLUMN TO TABLE  		       -   a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnDefinitionAndConstraint 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 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 BLOB COLUMN COUNT                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE TABLE BLOB COLUMN EXIST                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
SQLITE TABLE BLOB COLUMN POSITION              -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, NamedBlobColumn STRING)
SQLITE TABLE BLOB COLUMN NAME$                 -  a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, NumberedBlobColumn INTEGER)
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, ColumnNameA INTEGER, OriginalCellString STRING, NewCellString STRING,[ WhereColumnB STRING,[ HasAStringValueOfC STRING,[ AndColumnC STRING,[ HasStringValueOfD 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 FIND TABLE BLOB MEMBLOCK                -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, FindBlobInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING, AndWhereColumnnC1 INTEGER,[ HasValueC2 STRING,[ MemblockToCreateID INTEGER])
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 GET LAST SQL QUERY$                     -  a function returning a STRING value from <*no parameters*>
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 RECORD ROW BLOB MEMBLOCK                -  a function returning an INTEGER value from (DatabaseID INTEGER, ColumnNumber INTEGER, MemblockToBeCreatedID 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 LAST UPDATING SQL STATEMENT$            -  a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
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 SET MEMBLOCK BLOB WHERE                 -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, BLOBColumnToBeEffected STRING, MemblockID INTEGER, WhereColumnA STRING, EqualsValueA STRING,[ AndWhereColumnB STRING,[ EqualsValueB STRING])
SQLITE INSERT MEMBLOCK BLOB                    -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, BLOBColumnToBeEffected STRING, MemblockID INTEGER)
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 SUPERSTRING FROM TABLE             -  a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
SQLITE MAKE SUPERSTRING FROM RECORDSET         -  a function returning an INTEGER value from (DatabaseID INTEGER)
SQLITE SUPERSTRING EXIST                       -  a function returning an INTEGER value from <*no parameters*>
SQLITE GET SUPERSTRING$                        -  a function returning a STRING value from <*no parameters*>
SQLITE CLEAR SUPERSTRING                       -  a function returning an INTEGER value from <*no parameters*>
SQLITE SUPERSTRING COLUMN COUNT                -  a function returning an INTEGER value from <*no parameters*>
SQLITE SUPERSTRING ROW COUNT                   -  a function returning an INTEGER value from <*no parameters*>
SQLITE SUPERSTRING GET COLUMN NAME$            -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE SUPERSTRING GET COLUMN TYPE$            -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE SUPERSTRING GET COLUMN NAME WITH TYPE$  -  a function returning a STRING value from (ColumnNumber INTEGER)
SQLITE SUPERSTRING COLUMN NAMES FIELDSTRING$   -  a function returning a STRING value from <*no parameters*>
SQLITE SUPERSTRING COLUMN TYPES FIELDSTRING$   -  a function returning a STRING value from <*no parameters*>
SQLITE SUPERSTRING COLUMN NAMES AND TYPES FIELD-  a function returning a STRING value from <*no parameters*>
SQLITE SUPERSTRING GET STRING$                 -  a function returning a STRING value from (Column INTEGER, Row INTEGER)
SQLITE SUPERSTRING SET STRING                  -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER, NewStringValue STRING)
SQLITE SUPERSTRING GET INTEGER                 -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER)
SQLITE SUPERSTRING SET INTEGER                 -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER, NewIntegerValue INTEGER)
SQLITE SUPERSTRING GET FLOAT                   -  a function returning a FLOAT value from (Column INTEGER, Row INTEGER)
SQLITE SUPERSTRING SET FLOAT                   -  a function returning an INTEGER value from (Column INTEGER, Row INTEGER, NewFloatValue INTEGER)
SQLITE MAKE TABLE FROM SUPERSTRING             -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName 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 SET STRING                        -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER, NewString STRING)
SQLITE ARRAY INTEGER                           -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE ARRAY SET INTEGER                       -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER, NewInteger INTEGER)
SQLITE ARRAY FLOAT                             -  a function returning a FLOAT value from (ColumnNumber INTEGER, RowNumber INTEGER)
SQLITE ARRAY SET FLOAT                         -  a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER, NewFloat INTEGER)
SQLITE MAKE TABLE FROM ARRAY                   -  a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName STRING,[ NumberedColumnAsPrimaryKey INTEGER,[ NamesColumnsToBeIndexed STRING])
SQLITE EXPORT 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*>

a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...

Attachments

Login to view attachments

Back to top

Profile PM Email

Duffer

21

Years of Service

User Offline

Joined: 9th Feb 2003

Location: chair

Posted: 30th Nov 2014 15:26 Edited at: 30th Nov 2014 17:04

Link

Have posted a revised version above - maybe now it will work!

a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...

Back to top

Profile PM Email

Sorry your browser is not supported!

Work in Progress / Sqlite, ODBC and a Database Manager?

Attachments