Input string was not in a correct format.Couldn't store <> in SortOrder Column. Expected type is Int64.
Posted: Fri 10 Jan 2020 16:26
Dear sirs,
today I started getting the error mentioned in the subject.
(Input string was not in a correct format.Couldn't store <> in SortOrder Column. Expected type is Int64.)
I have not changed anything in the code, neither in the database structure and it used to work perfectly.
Here is the code and where the error occures:
The table structure is the following (I use SQLite Expert Personal for the DB):
devart.data version 5.0.2296.0
devart.data.sqlite version 5.14.1504.0
I do not try to insert something in the DB with a wrong type because as you can see the error occures in the filling of the dataset and it used to work perfectly the last time I ran this code (before 4 months or so). What could it possible be wrong?
Thanks in advance
today I started getting the error mentioned in the subject.
(Input string was not in a correct format.Couldn't store <> in SortOrder Column. Expected type is Int64.)
I have not changed anything in the code, neither in the database structure and it used to work perfectly.
Here is the code and where the error occures:
Code: Select all
Dim dsSave As New DataSet
Dim cmndSave As New SQLiteCommand("SELECT * FROM [Translations] WHERE lang='" & _
ds.Tables("trns").Rows(0).Item("lang") & "'", conn)
Dim daSave As New SQLiteDataAdapter(cmndSave)
Dim cmbld As New SQLiteCommandBuilder(daSave)
daSave.UpdateCommand = cmbld.GetUpdateCommand
daSave.DeleteCommand = cmbld.GetDeleteCommand
daSave.InsertCommand = cmbld.GetInsertCommand
Debug.Print(daSave.InsertCommand.CommandText)
Debug.Print(daSave.SelectCommand.CommandText)
Debug.Print(daSave.DeleteCommand.CommandText)
Debug.Print(daSave.UpdateCommand.CommandText)
daSave.Fill(dsSave, "sv") <---- the error occurs in this lineCode: Select all
CREATE TABLE "Translations"(
[key] TEXT,
[lang] TEXT,
[value] TEXT,
[lkey] INTEGER,
[SortOrder] INTEGER,
[LastUpdatedAt] LARGEINT,
PRIMARY KEY([key], [lang]) ON CONFLICT FAIL);
devart.data.sqlite version 5.14.1504.0
I do not try to insert something in the DB with a wrong type because as you can see the error occures in the filling of the dataset and it used to work perfectly the last time I ran this code (before 4 months or so). What could it possible be wrong?
Thanks in advance