I am using SQLite 3 as backend database in my asp application. I am using
SQLite3 ODBC driver (latest version).
Table Design
------------
CREATE TABLE log
( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
from_value TEXT NULL,
to_value TEXT NULL
);
INSERT 10 RECORDS IN TO DATABASE
--------------------------------
Const adOpenStatic = 3
Const adLockOptimistic = 3
Dim SQLString ,objConnection
Dim fromVal,toval
Set objConnection = CreateObject("ADODB.Connection") for a = 1 to 10
objConnection.Open "DSN=Test;uid=;pwd=;"
fromVal = "FROM Value : "& a
toVal = "To Value : "& a
SQLString = "INSERT INTO log(from_value, to_value) VALUES ('"& fromVal
& "'
,'"&toVal& "')"
objConnection.Execute SQLString
objConnection.Close
next
Access records in the log table
-------------------------------
Dim LogRs,SQLStmt
SQLStmt = "SELECT * FROM log "
LogRs.ActiveConnection = "DSN=Test;uid=;pwd=;"
LogRs.Source= SQLStmt
LogRs.CursorType = 3'ADOPENSTATIC
LogRs.CursorLocation = 2 'ADUSESERVER
LogRs.LockType = 3 'ADLOCKOPTIMISTIC
LogRs.Open()
RecordCount = LogRs.RecordCount
If I use datatype of from_value/to_value as TEXT ,I get RecordCount as zero
which is wrong.
If I use datatype of from_value/to_value as Varchar(1600) ,I get RecordCount
as 10 which is correct.
If I use datatype of from_value/to_value as Varchar(1600) and tried to put
more than 1600 charcters in it ,SQLite stores data in DB. While retrieving
the data I get the error Arguments are of the wrong type,are out of
acceptable range,or are in conflict with one another.
I enabled ODBC trace log ,but its empty after running my application.So I
am not sure where it is ODBC problem or SQLite ODBC driver error?
If I open table (database) in SQLite Studio I could see data without any
error.
If I use MS Access with same table design and same code, I don’t get any
error . The code works fine as expected .
--
View this message in context:
http://www.nabble.com/SQLite-3-and-SQliteODBC-Driver-tf4551163.html#a12988036
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
