Hi, Don-
Sorry to not reply sooner--I've been out of town.

You don't need the quotes around SUBMOTOR.

>eView gives me the same error message and so does maintaining the view in code.
>
>that is it chokes on the first line :
>
>CREATE SQL VIEW "SUBMOTOR" ;
> AS SELECT * FROM motor WHERE Motor.equip_id = ?equip.eqno

...snip