I have a query where I need to add a record, edit a record, and
delete a record.

The code below is what I am using to edit the record. Do I need to
put this statement in the Edit SQL property? All the help
information I have read says I don't need to use the Edit, Insert,
and Delete SQL properties.

select * from mytable
where filekey = :filekey for update

Where should I put this code? In the SQL Tstrings? Can I do that
when I need a different statement for each(Add,Edit,Delete)???

Any help with this is greatly appreciated.

Kristy