AltSQLite and Database Query Builder

[Michael Mandaville]

I am currently using altSQLite3 and trying to see if I can use the Database
Query Builder to hook it into.  I have a few questions.


1.   Once the database has been created, is it best placed in the same
folder as the Applications Mainstack?

Or in the folder with the Revolution Application?


2.  In Database Query Builder, I have the following questions:

A)Host:
In the tutorial, the writer puts in "RunRev".
Does this mean that the Host is the Revolution Studio Application?
But should I put in "localhost"?
Or name it anything that I want?
Or Use the Filepath to the Database file? (not the Application)


B) Database
Is this only the name of the Database?   e.g..  "TestDatabase"

OR should it include the entire FilePath
"A:\\HardDriveName\Applications\Revolution Studio\Work\TestDatabase"


Or should it ALWAYS have the extension?   e.g. "TestDatabase.sqlite"
Should the extension be ".sqlite"  OR "dbsqlite" OR "altsqlite3"

C)User
If it is on my local machine, then do I have to put in a User Name?
Or is there a default if I am NOT on an external server?
Or can I leave it blank to connect?

D) Password:
If it is on my local machine, then do I have to put in a Passwoord?
Or is there a default if I am NOT on an external server?
Or can I leave it blank to connect?


I also learned from Chris at altuit that in the Altuit tutorial's CONNECTION
BUTTON SCRIPT, the revdb_connect command...requires the commas.
E.g.
€"AppReg.db",,,,,

According to Chris,  "You need the commas.  They are extra parameters that
revdb uses when connecting to other database(Mysql,Postgres, Oracle and the
like)..In altSqlite we don't need them, but they still need to be passed to
the function call as empty."

A lot of people might already know that but not a Newbie like myself.

Thanks,

Revolutionary Michael