Sean,

I'm pretty limited on further time I can give to helping with this.
Some things are not clear so far and are getting muddier:

Did you actually ever manage to change anything?
ditto ditto delete anything?

Were you using SPs to do things or not? (If not, then some syntaxes are
suspect...)

Is this Partnum column the primary key?

What's the situation now and where does it need to go? i.e. restate the
problem and the objective as they currently stand.

Also consider downloading IB_SQL (free) from www.ibobjects.com (button top
right of home page) to use instead of IBConsole. This will give you more
control over the transactions. Run your executable stuff in the DSQL
window, multi-row selects in the Cursor window, replaceable params
supported in both.

/heLen

>