How to fill in the Database Query Builder?
R.Venzl-Schubert at t-online.de
Sat Jun 3 01:17:14 CDT 2006
I just go my first steps in using database with Revolution.
I bought a license von SQLite from Altuit and created my first
Then I created a stack and want to build a database query with the
Database Query Builder.
I studied the User Guide and the appropriated video but I cannot
connect to the db.
Whatever I tried I got the message:
There was an error in connecting to the database.
Please check that the connection fields are correct.
Revdb error: revdberr, invalid database type
Please give me a little help to fill in correctly:
Name: Query 1
User: my emailadress that I used to create the AppReg3.db
Password: my password that I used to create the AppReg3.db
The database is located in the folder "/Applications/Revolution
The stack is located in the folder "/Users/rvs/Documents/My
- - - - - - - - - - - - - - -
The script I created the AppReg3.db is:
put revdb_connect("sqlite3","AppReg3.db",,,,,"schubert at t-
online.de","XXxxXXxxxXxxXX") into tConID
if tConID is "" then
answer warning "Problem creating or accessing database!"
answer information "AppReg Connected! Your connection ID is:
" & tConID
put tConID into gConID
- - - - - - - - - - - - - - - -
The script I created the table is:
on handleRevDBerror p
case item 1 of p is "revdberr"
return "revDB Error: " & p
case "syntax error" is in p
return "Database Error: " & p
if gConID is "" then
answer information "No Database is Connected to, please go
back 1 step and connect to the Database!"
put "CREATE TABLE Karten_Daten(KarteID integer primary key,Frage
text,Antwort text)" into tSQL
put revdb_execute(gConID,tSQL) into tTmp
if the result is not empty then
answer warning the result
answer information "Number of Tables Added: " & tTmp
More information about the use-livecode