Subject Re: [firebird-support] behavior of select into in a result with > 1 record
Author Martijn Tonies
Hi,

> "select anythink from table into :anythink"
> what happen if my select return more than one records ?
> The first will be used and assigned to my variable?

You will receive an error - something along the lines of
"Multiple rows returned in a singleton select".



With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com