Source language: Translate to:

SQLite

Questions about our Advanced Database plug-in

Moderator: Neosoft Support

SQLite

Postby ebear » Sat Jan 31, 2015 12:12 pm

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 http://www.ch-werner.de/sqliteodbc/

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.
hpwNBVersion=585.2
LastError=Action references a subroutine that does not exist.
LdB.$Status=Connected

What I'm doing wrong????

Thanks a lot for you response...

Regards,

Eric Beerhorst
http://www.lunarsoftware.eu - Lunar Software ERP database Development. Manufacturing processes, Document management, QMS, Stock management. Standalone solutions or connected to Helios Orange and other ERP systems.
User avatar
ebear
 
Posts: 270
Joined: Wed Jan 18, 2012 3:12 am
Location: Vrchlabi - Czech republic

Re: SQLite

Postby ebear » Sat Jan 31, 2015 1:53 pm

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,

Eric
http://www.lunarsoftware.eu - Lunar Software ERP database Development. Manufacturing processes, Document management, QMS, Stock management. Standalone solutions or connected to Helios Orange and other ERP systems.
User avatar
ebear
 
Posts: 270
Joined: Wed Jan 18, 2012 3:12 am
Location: Vrchlabi - Czech republic


Return to NeoBookDBPro

Who is online

Users browsing this forum: Yahoo [Bot] and 1 guest