SQLite - help getting started

David · Post by **David** » Fri Aug 11, 2006 6:10 pm

Hi.

Could anyone help me get started with using SQLite with PB please? I have not done any programming for some time but my boss has recently asked me to write a small programme for where I work. Once I can write a very basic programme I'll learn the rest through the documentation but I'd be very grateful for some help getting started. Thank you.

Pureabc · Post by **Pureabc** » Fri Aug 11, 2006 6:29 pm

You might want to take a look at this very good example (by netmaestro):

http://www.purebasic.fr/english/viewtopic.php?t=22209

Good luck.

David · Post by **David** » Fri Aug 11, 2006 7:11 pm

Thank you Pureabc, but I have not been able to run the example. I get the following error message:

"Line 49: SQLite3_InitLib is not a function, array, macro or linked list."

I am running PB4 on Windows XP. Does anyone have any idea what the problem is please?

Thanks.

netmaestro · Post by **netmaestro** » Fri Aug 11, 2006 8:01 pm

You have to put the PBOSL SQLite3 library into your userlibraries folder. You can download it from PureArea.net. Also, you'll have to have a movies database made with the structure described in the sourcecode. SQLite has a utility you can use for that, it's easy. Just make a database and stick a couple of records in it and you're off and running.

David · Post by **David** » Fri Aug 11, 2006 8:17 pm

Thank you very much netmaestro. There's no problem now.

GG · Post by GG » Thu Oct 19, 2006 11:00 am

Is new DLL Sqlite 3.3.8 compatible with PBOSL_SQlite ?

rsts · Post by **rsts** » Thu Oct 19, 2006 12:31 pm

I loaded it and it worked ok but I went back to the older one due to size - I include the dll in my exe.

cheers