At 04:59 PM 3/03/2005 +1300, you wrote:

>Hi
>
>I get an 'Unsuported column type: 0' error whenever I do this.
>
>
>I have just discovered it is due to my component set, I am using an
>IBOQuery to run this.

Aha!! This is because IBOQuery parser thinks a colon-ised fieldname is a
parameter and you haven't told it otherwise. That's a trap with using
IBOQuery (which is designed for scrollable SELECT queries) to perform
DDL. Use an ib_dsql, and make sure you set the property ParamCheck to False.

(You might also achieve the same thing by setting this property False on an
IBOQuery...raise further questions on the IBO support list....)

./heLen