Marten Feldtmann schrieb:
[EMAIL PROTECTED] schrieb:
Make sure sqlite3_column_double() really is declared to
return a double and that dVal really is declared to be a
double. If both of those things check out, then I would
assert that this is a compiler bug.
Yes, I think also that this is a
Can you try this code:
Dim sqlite As New SQLiteDb.Connection
With sqlite
.Open "Data Source=c:\temp\test.db"
If .State = slStateOpen Then
.Execute "CREATE TABLE [A3Test8CA_F] ([PATIENT_ID] INTEGER,
[ENTRY_ID] INTEGER, [READ_CODE] TEXT, [TERM_TEXT] TEXT,
I don't really need the loop and I could just do:
If SQLiteConn.State <> slStateOpen Then
SQLiteConn.Open
End If
Will try that in a bit. Still, the connection gets closed and opened all the
time with the same routine and no problem at all, except for in that shown
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
This is the full Sub that sets the connection, except for leaving out a
msgbox text:
Sub SetSQLiteConnection(Optional bNoRecords As Boolean, _
Optional strDBFile As String, _
Optional lPageSize As Long = -1)
Dim strDBPath As String
If
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
This gives all the right answers, suggesting the object is set fine and the
connection is open:
If SQLiteConn Is Nothing Then
MsgBox "nothing"
End If
MsgBox SQLiteConn.State = slStateOpen
It still got me stumped.
RBS
-Original Message-
Yes, I am using the VB wrapper from TerraInformatica and I am coding in VBA
and using ADO. The error doesn't show in the help and nil found with a
websearch either.
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 09 December 2006 22:36
To:
It sounds to me like you're using ADO? How do you know for sure that
the connection is truly open?
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Saturday, December 09, 2006 5:36 PM
"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
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
Thanks for any advice
RBS
How about Pascal? Wordy like Basic, powerful like "C".
Download Turbo Delphi, and give it a look.
Fred
> -Original Message-
> From: RB Smissaert [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 07, 2006 4:11 PM
> To: sqlite-users@sqlite.org
> Subject: RE: [sqlite] Interbase to
[EMAIL PROTECTED] schrieb:
Make sure sqlite3_column_double() really is declared to
return a double and that dVal really is declared to be a
double. If both of those things check out, then I would
assert that this is a compiler bug.
Yes, I think also that this is a very low level error - I've
Marten Feldtmann <[EMAIL PROTECTED]> wrote:
> John Stanton schrieb:
> > Maybe your statement does not reference a valid row.
> >
> No, actually I have in my test program several lines to retrieve
> the values in different ways:
>
>sql = "select aColumn from TESTME2;";
>
"Hickey, Larry" <[EMAIL PROTECTED]> wrote:
> I have a system requirement that feeds thousands of keyed records, each of
> which contains a blob of around a meg or so into an sqlite database. Ok so
> far. But the records come from multiple
> processes, and I can't afford to do have commits after
John Stanton schrieb:
Maybe your statement does not reference a valid row.
No, actually I have in my test program several lines to retrieve
the values in different ways:
sql = "select aColumn from TESTME2;";
sqlite3_open("c:\\sunittest.db", );
sqlite3_prepare(db, sql, strlen(sql), ,
16 matches
Mail list logo