PureBasic Forums - English

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.

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.

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.

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.

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

Is new DLL Sqlite 3.3.8 compatible with PBOSL_SQlite ?

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