Well i have confirmed the database is opening properly and existing tables can be seen (used test_05 for this and a table i had created).
I know it is dropping the table as a second call to test_05 shows the table is gone.
It is now reporting a error with an error number. I am checking for what this means...
Building test_01
Compiling:test_01.bmx
flat assembler version 1.66
3 passes, 9658 bytes.
Linking:test_01.debug.exe
Executing:test_01.debug.exe
DebugLog:Database Loaded
DebugLog:Database is Opened
DebugLog:what tables exist
DebugLog: 1. person
DebugLog: 2. tblTest
DebugLog:Table Dropped
DebugLog:what tables exist after dropping Person
DebugLog: 1. tblTest
DebugLog:s = CREATE TABLE person (id integer primary key AUTO_INCREMENT, forename varchar(30), surname varchar(30) )
DebugLog:Tried to Execute Query
DebugLog:(3) Error executing statement : [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. (-3551) :
Process complete
I know it is dropping the table as a second call to test_05 shows the table is gone.
It is now reporting a error with an error number. I am checking for what this means...
Building test_01
Compiling:test_01.bmx
flat assembler version 1.66
3 passes, 9658 bytes.
Linking:test_01.debug.exe
Executing:test_01.debug.exe
DebugLog:Database Loaded
DebugLog:Database is Opened
DebugLog:what tables exist
DebugLog: 1. person
DebugLog: 2. tblTest
DebugLog:Table Dropped
DebugLog:what tables exist after dropping Person
DebugLog: 1. tblTest
DebugLog:s = CREATE TABLE person (id integer primary key AUTO_INCREMENT, forename varchar(30), surname varchar(30) )
DebugLog:Tried to Execute Query
DebugLog:(3) Error executing statement : [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement. (-3551) :
Process complete