[sqlite] RE: where to place RAISE(ROLLBACK/ABORT/FAIL/IGNORE,error) in a trigger

-Original Message- From: jim [mailto:[EMAIL PROTECTED] Sent: Saturday, December 27, 2003 9:43 PM hi- i am brand new to playing with an sqlite database. i made a trigger in sqlite using TCL scripting language. I used TCL script with triggers to validate data. My problem is I cant figure

[sqlite] newbie asks for help: can sqlite store files??

Hello everybody, i discovered sqlite just few hours ago. And it is an absolutely amazing product. I haven't experienced with database yet. So I would like to ask you some questions. 1. Is sqlite able to store files (document files, pictures, zip files) which are bigger than 1 mb?? because

RE: [sqlite] Sqlite & COM/EXE server

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 December 2003 16:19 To: [EMAIL PROTECTED] Subject: RE: [sqlite] Sqlite & COM/EXE server > Hi, > > I've used SQLite in a variety of COM situations without problems. > > What is your application environment

RE: [sqlite] Sqlite & COM/EXE server

> Hi, > > I've used SQLite in a variety of COM situations without problems. > > What is your application environment (asp/client-server/desktop)? > Is your COM EXE written in VB? > Are you using a custom DLL to interface to the SQLite DLL? > How is your COM EXE threaded (free/apartment/single)?

Re: [sqlite] Sqlite & COM/EXE server

> Hi, > > Does anyone use Sqlite in a COM/EXE server? > > I always get the error "no such table: sqlite_temp_master" from Sqlite when I call > any of its API > function from within a COM EXE. Out of many attempts I discovered that if I set my > COM EXE to run as > an Interactive User (by

[sqlite] Sqlite & COM/EXE server

Hi, Does anyone use Sqlite in a COM/EXE server? I always get the error "no such table: sqlite_temp_master" from Sqlite when I call any of its API function from within a COM EXE. Out of many attempts I discovered that if I set my COM EXE to run as an Interactive User (by using DCOMCNFG) then