[Gambas-user] Writing a Gambas/SQLite tutorial

[AenDeuRyu]

Hi, I'm writing up a tutorial that shows newbies with
a Visual Basic background how to integrate Gambas and
SQLite. Dumb questions -- since I'm new to the Gambas
way of doing things myself...

1) The first time I ran gambas-database-manager to set
up an sqlite server, after I finished creating the
server, I got an error when trying to double-click on
it (can't remember the exact wording). Now, this was
fixed after I ran a "Scan Database Servers", but
there's a problem. I'd actually like to recreate that
error-message-scenario for a screenshot, but at the
moment all new databases that I create are instantly
accessible without the scan. Is there some sort of tmp
file or config file or something I can delete, so that
when I run the g-d-m again it'll be like I'm running
it for the first time, so I can get that error again?

1a) Further to 1, is there a reason why that error
occurs? Does the scan need to be run once, just to
initialize something that won't have to be initialized
again? I can handle a "that's just the way things work
right now" response, if that's what it is, I just want
to put it into the tutorial.

2) Just want to fact-check the following statements:
* gambas needs the qt libraries to run
* the default install of gambas gives you both the
gambas IDE and the gambas-database-manager
* to get SQLite integration, users need to install
both libsqlite AND lib.gb.db.sqlite.
* gambas2 default-installs its libraries to
/usr/local/lib/gambas2, whereas the deb package for
gambas-gb-db-sqlite installs its libraries to
/usr/lib/gambas

3) The documentation on this is a little hard to come
by (the main reason I'm writing my own), so I can't
verify the following assertion. C programs can
actually load the sqlite library which acts like a
mini database engine contained within the C program,
whereas gambas at this point interacts with sqlite
databases through external connections, much like it
does with postgresql and mysql, and also like the way
ODBC works on windows. Is that right? Is there a
better explanation? Can gambas actually handle sqlite
databases the way C code does? If not, will that be an
option in the future?

4) Will gambas components at some point have
datasource attributes that allow them to dynamically
interact with databases, the way that Visual Basic
does? I don't personally care one way or the other,
but I want to mention this in the tutorial.

Anyhow, hope that's not too many questions (because I
might have more later). I'm having a whole hell of a
lot of fun working in Gambas, by the way. I used to
teach Visual Basic back in the heyday, and it's really
fantastic to see how much functionality Gambas has at
this point.

-a

______________________________________________________________________ 
Post your free ad now! http://personals.yahoo.ca