> What is the syntax of the SQL needed to delete a single record via
> DeleteSQL? Do you have to set up a cursor and use WHERE CURRENT OF?

No, you need to use actual values that will uniquely identify the record.

WHERE MYCOL = :OLD_MYCOL

If MYCOL is a primary key then this will do it.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com