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
.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
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
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
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
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
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
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
"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
9 matches
Mail list logo