RE: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread Eric Pankoke
r Point Of Light Software http://www.polsoftware.com/ -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Saturday, December 09, 2006 6:39 PM To: sqlite-users@sqlite.org; [EMAIL PROTECTED] Subject: RE: [sqlite] Operation is not allowed when the object is closed This

RE: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread RB Smissaert
.org Subject: Re: [sqlite] Operation is not allowed when the object is closed On Sat, 9 Dec 2006 23:38:47 -, you wrote: > On Error Resume Next > Do While SQLiteConn.State = slStateClosed > SQLiteConn.Open > Loop I has been quite some time since I wrote VB, but I'll give it

Re: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread Kees Nuyt
On Sat, 9 Dec 2006 23:38:47 -, you wrote: > On Error Resume Next > Do While SQLiteConn.State = slStateClosed > SQLiteConn.Open > Loop I has been quite some time since I wrote VB, but I'll give it a try. You seem to assume that SQLiteConn.Open raises an error when it fails. If it

RE: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread RB Smissaert
is a valid SQL to create a table: CREATE TABLE [A3Test8CA_F] ([PATIENT_ID] INTEGER, [ENTRY_ID] INTEGER, [READ_CODE] TEXT, [TERM_TEXT] TEXT, [START_DATE] INTEGER, [NUMERIC_VALUE] REAL) RBS -Original Message----- From: Kees Nuyt [mailto:[EMAIL PROTECTED] Sent: 09 December 2006 23:27 To: sqlite

Re: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread Kees Nuyt
On Sat, 9 Dec 2006 22:24:59 -, you wrote: > Keep getting this error when trying to create a table > in SQLite. There is a valid connection object and it > is open and I have no idea what is causing this: > > Operation is not allowed when the object is closed. > Error number: 3704 Please show

RE: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread RB Smissaert
al Message- From: Eric Pankoke [mailto:[EMAIL PROTECTED] Sent: 09 December 2006 22:47 To: sqlite-users@sqlite.org Subject: RE: [sqlite] Operation is not allowed when the object is closed It sounds to me like you're using ADO? How do you know for sure that the connection is truly open? Eric

RE: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread RB Smissaert
users@sqlite.org Subject: Re: [sqlite] Operation is not allowed when the object is closed "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Keep getting this error when trying to create a table in SQLite. There is a > valid connection object and it is open and I have no

RE: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread Eric Pankoke
PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Operation is not allowed when the object is closed "RB Smissaert" <[EMAIL PROTECTED]> wrote: > Keep getting this error when trying to create a table in SQLite. There is a > valid connection object and it is open and I h

Re: [sqlite] Operation is not allowed when the object is closed

2006-12-09 Thread drh
"RB Smissaert" <[EMAIL PROTECTED]> wrote: > Keep getting this error when trying to create a table in SQLite. There is a > valid connection object and it is open and I have no idea what is causing > this: > > Operation is not allowed when the object is closed. > Error number: 3704 > Ain't no such