AFAIK the table name must be quoted only if it could be confused with a reserved word...17.2.2005 kello 11:45, Anirban Sarkar kirjoitti:
I mistyped the entire sql statement. This is what my actual code looks like:
sqlite db1 "cesc_simputer.db"
#Inserting data into mri_output table
set connection_no { }
set insert_normal "insert into mri_output (pwd,ac_my,con_no) values ('$pass','$ac_mth$ac_yr','$sel_con')"
db1 eval insert_normal {} {
}
Please note that the problem is with the syntax of the sql statement.
Regards, Anirban Sarkar
Asko Kauppi wrote: Still, shouldn't the 'mri_output' (table name) be quoted?
so you can write:
CREATE TABLE mytable (a)
CREATE TABLE 'mytable' (a)
CREATE TABLE 'table' (a)
but you can't write
CREATE TABLE table (a)
Paolo
P.S. Please, replay at the bottom of received mails, it makes quoted parts more readable
