Recent content by notebinder

So I played with this based on theDBguy's feedback on reserved words. It now works if I use[] for all fields (not sure of the logic there, but .....): INSERT INTO notes ([name], [note], [data_size]) SELECT 'newname' AS [name], [note], [data_size] FROM templates WHERE id = 99 Thanks for all...

newname is the new value of the NAME field that I use for the new row.

It fails even if I use [name]. The error is "Syntax error in INSERT INTO statement" (very informative isn't it)

I have 2 simple tables with 3 columns and an autonumber primary key/ID column. One table is a TEMPLATE table from which I copy data into another NOTE table to create a new record. During this copy, I rename the template name field to create the new entry name. In MySql, this was very simple SQL...