Delete Query

Archived Topics
1

I am working on a screen where pen names are managed and want to delete a single row determined at run time.

This is what I want to do but need to have parameters for each .

fpmi.db.runUpdateQuery("DELETE FROM ctg_saved_pens WHERE point_id = 'pen1' AND saved_name = 'default' AND user_name = 'Tim'")

Since I will be deleting data I want to have your input before I start experimenting.

Thanks

2

Ok, that should be easy enough. Is there a question here? The script would look something like

[code]point = …
name = …
user = …

fpmi.db.runUpdateQuery(“DELETE FROM ctg_saved_pens WHERE point_id = ‘%s’ AND saved_name = ‘%s’ AND user_name = ‘%s’” % (point, name, user))[/code]