Problem updating table that its name starts with number

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for SQLite
Post Reply
hatzisn
Posts: 1
Joined: Tue 30 Oct 2018 08:33

Problem updating table that its name starts with number

Post by hatzisn » 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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Problem updating table that its name starts with number

Post by Pinturiccio » Fri 02 Nov 2018 14:25

We have reproduced the issue. We will investigate it and post here about the results as soon as possible.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Problem updating table that its name starts with number

Post by Shalex » Sat 11 Jan 2020 18:54

The name of the table should be quoted in the query. If you generate queries with SQLiteCommandBuilder, set its Quoted property to true.

Post Reply