I just tried creating a new procedure which referenced a bogus field name (this is using the enterprise manager interface).

CREATE PROCEDURE test AS
select * from account where myfield = 'test'

The error says Error: 207 Invalid column name 'myfield'

Like I said, this is normal for me. I have always taken the default settings upon installing SQL 7.0.

Guy


>What error are you seeing? Hmmm...I wonder...Is the database compatibility set to 6.5?
>
>-Mike