Roy,

<< A really interesting question is why are we getting different errors.
Same script, same tables different error I don't like the sound of that. Any
idea why. >>

Are you still getting the error ?  Your other post seemed to indicate that
it was working now.

I'm running the last script that you posted, and it works fine.

<< Didn't know you could do that - please add to my suggestions for the
manual. >>

It's mentioned for columns, but not variables or parameters:

http://www.elevatesoft.com/scripts/manual.dll?action=mantopic&id=edb1sql&category=0&topic=5

--
Tim Young
Elevate Software
www.elevatesoft.com