SpiderBasic

Is there an example of opening a SQLite db and acessing it? This is my first try at using SpiderBasic. To accomplish access to the DB, I wrote a program in PHP to access the SQLite DB. In SpiderBasic I send a request request = HTTPRequest(#PB_HTTP_Get, "http://localhost/person_api.php?personNum ...

My first SpiderBasic program.
I get errors in SpiderBasic whan I try to open this SQLite database. What am I doing wrong?
The error: "Bas parameter type, number expected instead of string"

The code:

If OpenDatabase(0, "C:\rbp101\projects\foodbank_project\data\foodbank.db")
Debug "Database ...

Thanks for the help. I'm going to study pure and spider some more.

Is there a book somewhere I can get. I'm about as smart as a rock when it comed to pure and spider.

I always like basic. people knock it. But I can pick up a basic program and understand it. Other languages not so much, especially ...

Most of my systems are in multiple sites.
The last winery system was all over, with sites in europe, south america, most states.
Had about 4 wineries where they crushed, blended. The bottling plant had 14 lines. One line did about 20K bottles per hour.
The glass plant was the largest in the us and ...

The system is winery management. Probably the most complex system I'v done. I've had lots of db experience.One complex system I was lead for installing HR, Payroll, Benefits for some of the largest Cities, like LA and Seattle. Plus others.
PeopleSoft has about 3500 tables. Just trying to figure out ...

I've never used pureBasic. I looked at it and I like it.
I was trying to figure out if pureBasic could open a server in the code. Or does it require something like Apache as a server.
Maybe I missed it, but I couldn't find docs on how to set it up to be standalone as server or how to do it with ...

Thanks for your advice. I think I found what I was looking for.
I'm sure as spiderBasic matures, it will have support.
I like the concept of spiderBasic, and will continue to have interest.

Thanks everyone for your support.

I looked at all the examples and can't see openDatabase.
I see where they test openDtatbase to see if it was opened and if not create a database.
I suspect the openDatabase does not support SQLite.

Maybe I should move on and find a language that opens sqlite databases.

Thanks for the help anyway..

I'm trying to open a sqlite database..
I'm having trouble trying to understand the steps involved.
I tried; OpenDatabase(1,"c:\rbp101\projects\foodbank_project\data\fb.db") But get errors.
So how do I open the database..
Thanks for the help..
Dan

Im the one who ask the question .
No one answered if it would work or not?
Anyway that is a work around and not a command to retrieve data by field name.
So does that question I posted work or not?

This is my first time looking at spiderbasic, so the question may be something everyone already does ...