Problem updating table that its name starts with number
Posted: Tue 30 Oct 2018 08:52
Dear sirs,
I face a problem when I alter (change records) in a dataset a table that its name starts with a number and try to update it.
This is what I get...
SQLite error
unrecognized token: ".10_Departments"
If I change the table name just to Departments it works perfect.
My dotConnect SQLite version is 5.11.1190.0.
My app is WinForms app that uses ADO.NET in .NET Framework 4.0 and I do the following imports:
-------------------------------
Imports System.Data
Imports Devart.Data.SQLite
-------------------------------
I tried also substituting the System.Data with the Devart.Data with no result.
Any suggestions on how to face this problem?
Thanks in advance
I face a problem when I alter (change records) in a dataset a table that its name starts with a number and try to update it.
This is what I get...
SQLite error
unrecognized token: ".10_Departments"
If I change the table name just to Departments it works perfect.
My dotConnect SQLite version is 5.11.1190.0.
My app is WinForms app that uses ADO.NET in .NET Framework 4.0 and I do the following imports:
-------------------------------
Imports System.Data
Imports Devart.Data.SQLite
-------------------------------
I tried also substituting the System.Data with the Devart.Data with no result.
Any suggestions on how to face this problem?
Thanks in advance