About SQLite and MS

Reimon · Post by **Reimon** » Mon Jan 11, 2010 10:23 am

Hi,

Has someone ever treated a SQLite database with Macro Scheduler? Please could you give me any examples?

Thanks and Regards,

Reimon

Post by **Marcus Tettmar** » Mon Jan 11, 2010 11:13 am

I haven't used it myself but as long as there is a connection provider available you should be fine with the native database functions.

Found this:
http://www.connectionstrings.com/sqlite

I also found various references to other ODBC drivers via google.

http://www.google.com/search?q=SQLLite+ ... on+strings

Bob Hansen · Post by **Bob Hansen** » Tue Jan 12, 2010 1:06 am

I haven't used this with SQLite either.

But if you need one for testing, I believe that Firefox versions 3.5.x use SQLite as their database for form field histories.

There is also a SQLite front end AddOn for Firefox, SQLIte Manager 0.5.7, that you may be able to use with Macro Scheduler also.

rullbandspelare · Post by **rullbandspelare** » Thu Feb 13, 2020 7:16 pm

I am using sqlite3.exe to manipulate a text db. works well.
Here: https://www.sqlite.org/2020/sqlite-tool ... 310100.zip

But I realy need help to get the DLL working.
here: https://www.sqlite.org/2020/sqlite-dll- ... 310100.zip

I can LibLoad it, but LibFunc> gives this error:
Line: 5 - Error Calling DLL: Possible wrong number or type of parameters? Message: Access violation at address 00000000. Read of address 00000000

LibLoad>sqlite3.dll,hDll
LibFunc>hDll,sqlite3_open,result,test.db,myDB
LibFunc>hDll,sqlite3_prepare,result,myDB, "SELECT * FROM files", -1, NULL, NULL
LibFree>hDll

Any input is welcome!
Thanks!
Rullbandspelare

About SQLite and MS

About SQLite and MS

Re: About SQLite and MS