> How do I change the message file?
>
> and when I add the : I get this message:
>
> Dynamic SQL Error SQL error code = -104
> Token unknown - line 15, column 36

That sounds strange, what is your exact code?

Also, FIRST 1 ID sounds a bit strange: this will return
1 random row cause you're not using an ORDER BY
clause.

Perhaps that would explain the "token unknown" error?
That it wants an ORDER BY on the FIRST ?

> Thats why I was trying to create the procedure without them, but when I

take

> them off i get that other message :(

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com