Page 1 of 1


PostPosted: Sat Jan 31, 2015 12:12 pm
by ebear
Hello All,

Instead of MS-SQL and MySQL i use normally I need an connection to a SQLite database. But something goes wrong...
I created a simple first test with a rectangle to show an table in a grid.

I use the ODBC from

In Neobook I use NeoBookDBPro as follows, in the startup actions:

Code: Select all
dbpOpenDatabase "LdB" "Provider=MSDASQL.1;Driver=SQLite3 ODBC Driver;Database=[PubDir]db\lunar.db"
dbpOpenTable "LdB" "tm" ""
dbpShowGrid "LdB" "tm" "Start_TM_Rectangle"

If I run this pub an error is showed with "The table tm could not be opened".
Otherwise the database seems to be connected, see below:

dbpError=The table tm is not open.
LastError=Action references a subroutine that does not exist.

What I'm doing wrong????

Thanks a lot for you response...


Eric Beerhorst

Re: SQLite

PostPosted: Sat Jan 31, 2015 1:53 pm
by ebear
Hello all,

I think I found the reason... In my database was for the language text a field cs-CZ and en-US. This gives the problem, after renaming to csCZ and enUS the problem was solved.
This is maybe a limitation in SQLite

Best regards,