Subject RE: [IBO] Not an IBO, only a SQL Question
Author Claudio Valderrama C.
> -----Original Message-----
> 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.

for select_statement
into :output_variables do
begin
suspend;
exit;
end

C.