On Tue, 9 Oct 2007 07:06:48 -0700 (PDT), you wrote:
> Is there a way for SQLITE to automatically load user
> defined functions at database instantiation or upon
> database connection?
You can put a file .sqliterc in the users homedirectory with
commands for the command line tool. They will be executed
immediately after the database is opened.
That might do (part of) what you need.
D:\opt\research>sqlite3 tmp/test_05.db3
-- Loading resources from C:\Users\knuytadm/.sqliterc
.bail ON
.mode tabs
select * from sqlite_master;
table testTbl testTbl 2 CREATE TABLE testTbl(
t_id INTEGER PRIMARY KEY,
t_name TEXT
)
SQLite version 3.4.2
Enter ".help" for instructions
sqlite>
Hope this helps.
Regards,
--
( Kees Nuyt
)
c[_]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
