Page 1 of 1

Problem updating table that its name starts with number

Posted: Tue 30 Oct 2018 08:52
by hatzisn
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

Re: Problem updating table that its name starts with number

Posted: Fri 02 Nov 2018 14:25
by Pinturiccio
We have reproduced the issue. We will investigate it and post here about the results as soon as possible.