Quote from
m.burdess on April 8, 2024, 11:29 pm
Sorry for the basic question but I am look at changing an Acces database to SQLite. I have created two tables with DB Browser for SQLite version 3.12.2 and it shows the two tables (GRO and Parish).
When I go to open the table and show it data all I have been getting is errors.
dbpOpenDatabase "GRO" "[PubDir]Burdess.db"
dbpTableExists "GRO" "Burdess" "[TEST]"
dbpGetTableNames "GRO" ";" "[Test12]"
dbpOpenTable "GRO" "Burdess" ""
dbpShowGrid "GRO" "BURDESS" "Rectangle1"
This gives me
GRO'$Status = Connected
TEST = True
Test12 = Burdess; (I do not have with this name)
dbpError = The Table Burdess could not be Opened
Can anyone point me in the direct, to solving this problem please.
Sorry for the basic question but I am look at changing an Acces database to SQLite. I have created two tables with DB Browser for SQLite version 3.12.2 and it shows the two tables (GRO and Parish).
When I go to open the table and show it data all I have been getting is errors.
dbpOpenDatabase "GRO" "[PubDir]Burdess.db"
dbpTableExists "GRO" "Burdess" "[TEST]"
dbpGetTableNames "GRO" ";" "[Test12]"
dbpOpenTable "GRO" "Burdess" ""
dbpShowGrid "GRO" "BURDESS" "Rectangle1"
This gives me
GRO'$Status = Connected
TEST = True
Test12 = Burdess; (I do not have with this name)
dbpError = The Table Burdess could not be Opened
Can anyone point me in the direct, to solving this problem please.