Subject Re: [firebird-support] Error while trying to create stored procedure - invalid request BLR at offset 218
Author Martijn Tonies
> 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

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
> them off i get that other message :(

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!