sqlite question

[Viktoras Didziulis]

Hi Peter, 
 
go to http://www.sqlite.org/sqlite.html . At the very end of this page there
are instructions on "using sqlite3 in a shell script". Some time ago I
successfully applied these to query my own sqlite3 databases like this: 
 
on mouseUp 
local cSQL 
local tmpTab 
 
put "sqlite3 my.db" && quote & field "fSQL" & quote into cSQL 
replace return with " " in cSQL 
set the itemdelimiter to "|" 
set the hideconsolewindows to true 
put shell(cSQL) into tmpTab 
replace "|" with tab in tmpTab 
put tmpTab into fld "fOut" #here the results go into text field with grids
 
put empty into tmpTab 
end mouseUp
 
All the best! 
Viktoras 
 
-------Original Message------- 
 
From: Peter Alcibiades 
Date: 28/05/2007 17:51:09 
To: How to use Revolution 
Subject: sqlite question 
 
Hi all, 
 
I have created an sqlite database with that wonderful tool, sqlitebrowser,
and 
got my data into it by hacking it into a csv import with regular expressions
 
So far so good. 
 
Now, how do I connect to it from rev? The revdb commands only seem to work 
with Mysql. Do I have to go out to the shell for everything and pass sqlite 
commands to it? Is there any documentation on this stuff anyplace? 
 
Note that this is Linux, so there is no altsqlite available nor query 
builder - this is 2.6.1. 
 
Thanks in advance for any hints, however cryptic, 
 
Peter 
_______________________________________________ 
use-revolution mailing list 
use-revolution at lists.runrev.com 
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences: 
http://lists.runrev.com/mailman/listinfo/use-revolution