OK, so I've re-jigged my ODBC database engine.
Hopefully it now works!
If you've installed MS Excel and/or Access you'll have the ODBC drivers for them - others are readily available on the internet.
In theory (and hopefully in practice) this plugin allows you to edit, parse, interrogate and change any database covered by an ODBC driver.
In addition, I have tried to make this as simple as I can.
In addition, I have also (untested) created some functions to export table(s) or whole databases (crudely) to a SQLITE database... That should come in darned handy...
In beta - so please test and let me know what works and what does not...
Current commands:-
Command Set:-
ODBC AVAILABLE - a function returning an INTEGER value from <*no parameters*>
ODBC DRIVERS COUNT - a function returning an INTEGER value from <*no parameters*>
ODBC GET DRIVER NAME$ - a function returning a STRING value from (DriverNumber INTEGER)
ODBC GET DRIVER DESCRIPTION$ - a function returning a STRING value from (DriverNumber INTEGER)
ODBC MS ACCESS DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC MS EXCEL DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC MS DBASE DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC SQLITE3 DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC FIREBIRD DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC MYSQL DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC SQL SERVER DRIVER EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC GET DSN$ - a function returning a STRING value from (DatabaseID INTEGER)
ODBC OPEN MS ACCESS CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN MS DBASE CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN MS EXCEL CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN FIREBIRD CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN MYSQL CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN SQLITE3 CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN SQL SERVER CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC OPEN OTHER CONNECTION - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING, ShorthandOfDriver STRING)
ODBC BASIC OPEN DATABASE - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC ADVANCED OPEN DATABASE - a function returning an INTEGER value from (DatabaseID INTEGER, DatabaseFilename STRING, Username STRING, Password STRING)
ODBC CLOSE DATABASE - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC DATABASE EXIST - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC CURRENT DATABASE - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC GET LAST ERROR$ - a function returning a STRING value from <*no parameters*>
ODBC TABLE EXIST - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
ODBC CREATE TABLE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnsDefinitionsAndConstraints STRING)
ODBC RENAME TABLE - a function returning an INTEGER value from (DatabaseID INTEGER, OriginalTableName STRING, NewTableName STRING)
ODBC GET TABLE COUNT - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC GET TABLE NAME$ - a function returning a STRING value from (DatabaseID INTEGER, NumberedTable INTEGER)
ODBC TABLE ROW COUNT - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
ODBC TABLE NAMED COLUMN EXIST - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
ODBC ADD COLUMN TO TABLE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnDefinitionAndConstraint STRING)
ODBC TABLE COLUMN NAME$ - a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
ODBC TABLE COLUMN INDEX - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnName STRING)
ODBC TABLE COLUMN DEFINITION$ - a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
ODBC TABLE COLUMN SIZE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER)
ODBC TABLE COLUMN COUNT - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
ODBC TABLE AS PRINTSTRING$ - a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, RightSetColumnLength INTEGER,[ FirstRow INTEGER,[ EndRow INTEGER])
ODBC TABLE CREATE FIELDSTRING OF COLUMNS$ - a function returning a STRING value from (DatabaseID INTEGER, TableName STRING,[ DelimeterForFieldString STRING])
ODBC TABLE CELL STRING$ - a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
ODBC TABLE CELL INTEGER - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
ODBC TABLE CELL FLOAT - a function returning a FLOAT value from (DatabaseID INTEGER, TableName STRING, ColumnNumber INTEGER, RowNumber INTEGER)
ODBC 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])
ODBC 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])
ODBC 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])
ODBC FIND TABLE STRING$ - a function returning a STRING value from (DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
ODBC FIND TABLE INTEGER - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, FindInColumnA STRING, WhereColumnB1 STRING, HasValueB2 STRING,[ AndWhereColumnC1 STRING,[ HasValueC2 STRING])
ODBC 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])
ODBC BEGIN SQL QUERY - a function returning an INTEGER value from (DatabaseID INTEGER, SQLQuery STRING)
ODBC 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])
ODBC FURTHER SQL QUERY - a function returning an INTEGER value from (DatabaseID INTEGER, AdditionalSQLQuery STRING)
ODBC MAKE TABLE FROM SQL QUERY RECORDS - a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName STRING)
ODBC QUERY RECORDS COUNT - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC QUERY COLUMNS COUNT - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC QUERY COLUMN NAME$ - a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
ODBC FIRST RECORD ROW - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC PREVIOUS RECORD ROW - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC NEXT RECORD ROW - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC GOTO RECORD ROW - a function returning an INTEGER value from (DatabaseID INTEGER, RowToGoTo INTEGER)
ODBC GOTO RECORD ROW WHERE - a function returning an INTEGER value from (DatabaseID INTEGER, WhereColumnNameA STRING, EqualsValueA STRING)
ODBC LAST RECORD ROW - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC RECORD COLUMN NAME$ - a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
ODBC RECORD COLUMN COUNT - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC RECORD ROW COUNT - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC RECORD ROW STRING$ - a function returning a STRING value from (DatabaseID INTEGER, ColumnNumber INTEGER)
ODBC RECORDSET AS PRINTSTRING$ - a function returning a STRING value from (DatabaseID INTEGER, RightSetColumnLength INTEGER,[ FirstRow INTEGER,[ EndRow INTEGER])
ODBC RECORD CURRENT ROW FIELDSTRING$ - a function returning a STRING value from (DatabaseID INTEGER,[ DelimeterForFieldString STRING])
ODBC RECORD ROW INTEGER - a function returning an INTEGER value from (DatabaseID INTEGER, ColumnNumber INTEGER)
ODBC RECORD ROW FLOAT - a function returning a FLOAT value from (DatabaseID INTEGER, ColumnNumber INTEGER)
ODBC FINISH SQL QUERY - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC UPDATING SQL STATEMENT - a function returning an INTEGER value from (DatabaseID INTEGER, UpdatingSQLStatement STRING)
ODBC ROWS AFFECTED BY UPDATE - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC 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])
ODBC INSERT ROW INTO TABLE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, SpecifiedNamedColumns STRING, SpecifiedValuesForThoseColumns STRING)
ODBC DELETE ROWS FROM TABLE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, WhereConditions STRING)
ODBC CREATE INDEX - a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING, TableName STRING, ColumnName STRING)
ODBC DROP INDEX - a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
ODBC DELETE INDEX - a function returning an INTEGER value from (DatabaseID INTEGER, IndexName STRING)
ODBC MAKE ARRAY FROM TABLE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING)
ODBC MAKE ARRAY FROM RECORDSET - a function returning an INTEGER value from (DatabaseID INTEGER)
ODBC ARRAY EXIST - a function returning an INTEGER value from <*no parameters*>
ODBC ARRAY COLUMN COUNT - a function returning an INTEGER value from <*no parameters*>
ODBC ARRAY ROW COUNT - a function returning an INTEGER value from <*no parameters*>
ODBC ARRAY GET COLUMN NAME$ - a function returning a STRING value from (ColumnNumber INTEGER)
ODBC ARRAY GET COLUMN TYPE$ - a function returning a STRING value from (ColumnNumber INTEGER)
ODBC ARRAY GET COLUMN NAME WITH TYPE$ - a function returning a STRING value from (ColumnNumber INTEGER)
ODBC ARRAY COLUMN NAMES FIELDSTRING$ - a function returning a STRING value from <*no parameters*>
ODBC ARRAY COLUMN TYPES FIELDSTRING$ - a function returning a STRING value from <*no parameters*>
ODBC ARRAY COLUMN NAMES AND TYPES FIELDSTRING$ - a function returning a STRING value from <*no parameters*>
ODBC ARRAY STRING$ - a function returning a STRING value from (ColumnNumber INTEGER, RowNumber INTEGER)
ODBC ARRAY INTEGER - a function returning an INTEGER value from (ColumnNumber INTEGER, RowNumber INTEGER)
ODBC ARRAY FLOAT - a function returning a FLOAT value from (ColumnNumber INTEGER, RowNumber INTEGER)
ODBC MAKE TABLE FROM ARRAY - a function returning an INTEGER value from (DatabaseID INTEGER, NewTableName STRING,[ NumberedColumnAsPrimaryKey INTEGER,[ NamesColumnsToBeIndexed STRING])
ODBC EXPORT ODBC ARRAY AS CSV - a function returning an INTEGER value from (CSVFileName STRING)
ODBC CLEAR ODBC ARRAY - a command with <*no parameters*>
ODBC DELETE ODBC ARRAY - a command with <*no parameters*>
ODBC EXPORT TABLE TO SQLITE - a function returning an INTEGER value from (DatabaseID INTEGER, TableName STRING, SqliteFileName STRING, Username STRING, Password STRING)
ODBC EXPORT TABLES TO SQLITE - a function returning an INTEGER value from (DatabaseID INTEGER, TableNames STRING, SqliteFileName STRING, Username STRING, Password STRING)
ODBC EXPORT DATABASE TO SQLITE DATABASE - a function returning an INTEGER value from (DatabaseID INTEGER, SqliteFileName STRING, Username STRING, Password STRING)
Total Number of Commands = 101
a long time dabbler with DBC and DBPro with no actual talent but lots of enthusiasm...
