The code will not accept the Table Name when using SQL INSERT INTO

When a string is passed to SQL I get “Can’t find Table Sud”. I checked the Object “Conn” Using the Watch facilities and 1 Table called “Sud” was shown. I should point out that all other other statements work ok. The Database is registered and the spelling and Capitals have been triple checked. The “Conn” object has the Table and Query can see the Table. Please help

Which database engine do you want connect to?

Try masking with

"INSERT INTO ""Sud"" (""Type"", ""Complete"", ""Start"") VALUES ('1','2','3')"

When using MariaDB/MySQL following masking will work also:

"INSERT INTO `Sud` (`Type`, `Complete`, `Start`) VALUES ('1','2','3')"
1 Like

Thank You again