In fact what I need is ANY row, that's why I didn't especified any order, I
just need a value.

On Nov 15, 2007 11:04 AM, Martijn Tonies <m.tonies@...> wrote:

>
>
> > 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
>
>
>


[Non-text portions of this message have been removed]