Delete from table script

Ignition
1

I’ve been trying to make a def block to delete old records from a database and I keep getting errors with this query.

def clearData (tableName, noDays): import system, datetime system.db.runPrepUpdate("Delete from ? where t_stamp < getdate() - ?",[tableName, noDays])

What am I missing?

2

Try this:
system.db.runPrepUpdate(“Delete from %s where t_stamp < getdate() - ?” % tableName,[noDays])

3

Can’t use question marks for table names.

4

What errors are you getting? Can you post them?