Hey Chuck,
Thanks for the reply, I'll give that a shot. Not real fond of turning off the error handler, but should be cool in this case.
How's it going otherwise? Still at Blashko? Take it easy,

jfh

>
>Hey John,
>I tried the code above and the ALTER TABLE seems to just go strait to the ON ERROR command. So if you turn it off I now works for me.
>
>

>TRY
>   ON ERROR *
>   ALTER TABLE myTable ADD PRIMARY KEY my_id TAG my_id
>   ON ERROR
>CATCH TO oException WHEN oException.ErrorNo = 1884
>     MESSAGEBOX( 'KAPOW!  Go fix your data.' )
>ENDTRY
>