Hi Carla,

>How can I create a primary key with a FOR clause (FOR !DELETED())

You can't do this programmatically, only through the Designer. Achieving the result in code requires hacking some binary memo fields in the DBC. If you arwe trying to re-generate a database and its tables check out the Stonefield Database Toolkit (www.stonefield.com).

Christof