Issue with creating Tables in Database

Question

Hello,I am trying to create Tables in a database using DirectSQL() function. There are 3 scenarions: DirectSQL("DRIVER=SQLite3 ODBC Driver; Database=Output.db","CREATE TABLE April2121 (Field1 INTEGER)"); Here the procedure is succesfully executed	DirectSQL("DRIVER=SQLite3 ODBC Driver; Database=Output.db","CREATE TABLE 20210421 (Field1 INTEGER)"); Here it generates an error	DirectSQL("DRIVER=SQLite3 ODBC Driver; Database=Output.db",FormatString("CREATE TABLE %s (%s INTEGER)",CurrentDate, Field1)); Here it generates an errorI need to create tables with names taken from string parameter “CurrentDate” and Column Name taken from string parameter “Field1” Current Date string parameter is defined as CurrentToString("%c%y-%m-%d").Could you please tell me where I am going wrong with this? I have attached screenshots for your reference.Thanks.

mohansx · Accepted Answer

@vishweshpatilThis is a SQLite issue. Table names must be strings.CREATE TABLE April2121 (Field1INTEGER)succeeds because you specify the table name as alphanumeric and it is automatically encoded as astring.CREATE TABLE 20210421 (Field1INTEGER)will fail, even if you execute on SQLite directly because 20210421 is not accepted as a valid table name. Modify your statement as,CREATE TABLE “20210421” (Field1 INTEGER)You can do this using formatString by escaping the quotations.DirectSQL("DRIVER=SQLite3 ODBC Driver; Database=Output.db",FormatString("CREATE TABLE \”%s\” (%s INTEGER)",CurrentDate, Field1))

Andrew · Answer

Hi @vishweshpatilWere you able to solve your SQL issue with Mohan’s suggestions?

Issue with creating Tables in Database

3 Attachments

2 replies

Reply

3 Attachments

Reply

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded