|Subject||Re: [firebird-support] Error while trying to create stored procedure - invalid request BLR at offset 218|
> How do I change the message file?That sounds strange, what is your exact code?
> and when I add the : I get this message:
> Dynamic SQL Error SQL error code = -104
> Token unknown - line 15, column 36
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 Itake
> them off i get that other message :(Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!