Hi, I am using ODBC MFC API with firebird.
I created a Store procedure thats selects a record, process it and
returns the results. However if no results we found, MFC always gets
a result of empty values. The recordset in MFC will always have 1
row of data which will break my code as i cant check for BOF in the
cursor position to determin if any records were found.

Basic structor of my SP is as follows

...
RETURNS(
return1,
return2,
return3
)
...
BEGIN
SELECT var1, var2, var3 FROM TABLE WHERE condition = condition1
into : return1, :return2 , return3:
SUSPEND;
...

How would i adjust my SP so that if no records are found MFC will
not get a recordset of garabe values.

Or a SP will always return a recordset no matter what the values?

thanks in advance for any help

Zak