Subject | RE: [IBO] Not an IBO, only a SQL Question |
---|---|
Author | Claudio Valderrama C. |
Post date | 2001-04-22T21:55:32Z |
> -----Original Message-----for select_statement
> From: Gerhard Schober [mailto:gjschober@...]
> Sent: Domingo 22 de Abril de 2001 16:08
>
> A SELECT statement is getting some values with INTO
> to some variable. Everything works fine, but if
> the result of the SELECT statement is more the 1 record,
> an SQL error "Multiple Row in singleton select" will appear.
>
> Is there an easy way to read only the first record from
> the result ? It doesn't matter if there will be more the one.
into :output_variables do
begin
suspend;
exit;
end
C.