You are fetching 2 variables from the same row. In other words is your where
returning only one row?
select variable1 = field1, variable2 = field2
where id = ...
"Gerhard Kashofer" <gerhard.kashoferesa-at.at> wrote in message
> i want to read two fields of a specified row of a table
> into 2 variables.
> Is it better to declare a cursor and read both fields
> into the variables within a single select or not using a
> cursor and read both fields using 2 ...