How do I pass a table’s name as a parameter in MyAccess?
query.SQL.Text := ‘INSERT INTO :table VALUES (ID = 2, Name = ”John”, Value = 1.1);’; query.ParamByName(‘table’).AsString := ‘testtable’; This leads to the table’s name being put in quotes, thus breaking MySQL syntax. This makes sense, but it means I have no idea of how to actually have the table name as a parameter. Thanks ! […]
How do I pass a table’s name as a parameter in MyAccess?
query.SQL.Text := ‘INSERT INTO :table VALUES (ID = 2, Name = ”John”, Value = 1.1);’; query.ParamByName(‘table’).AsString := ‘testtable’; This leads to the table’s name being put in quotes, thus breaking MySQL syntax. This makes sense, but it means I have no idea of how to actually have the table name as a parameter. Thanks ! […]
How do I pass a table’s name as a parameter in MyAccess?
query.SQL.Text := ‘INSERT INTO :table VALUES (ID = 2, Name = ”John”, Value = 1.1);’; query.ParamByName(‘table’).AsString := ‘testtable’; This leads to the table’s name being put in quotes, thus breaking MySQL syntax. This makes sense, but it means I have no idea of how to actually have the table name as a parameter. Thanks ! […]