"Table.Fetch Single" Gets No Data

[ka4niv]

\"Table.Fetch Single\" Gets No Data

OK -- this is a newbie question ...

Table.Fetch Single returns with SV File IO Status not equal to CO Success.

SQL.LOG says return code is SQL_NO_DATA_FOUND, but I can see the data right where it is supposed to be.

I will figure that out eventually, but here is the real question: In the ER, How do I sense the reason that the Fetch failed and give the user some kind of feedback as to what happened, like "No Data Found"?

Thanks Again ...

Maurice
ES:AS400 SP 14 (yes, I know) DEP:NT 4.0 Citrix

 

[DSauve]

Re: \"Table.Fetch Single\" Gets No Data

Maurice,

To test for no record found, use an IF statement checking to see if SV File IO Status = CO_SUCCESS. If so, process as normal. If not, your feedback to the end-user will depend on the type of entity in which you're working (Application or UBE). If a UBE, you can call a Custom Section with a message stating that no data is found, or can just populate an existing detail line with a message, or one of many other methods. If this is an Application, you can insert a custom grid row and somehow (either through text or color) indicate that no record was found.

Don Sauve
Wagstaff, Inc.
OW XE, Update 1, SP15.1, HP-UX 11.0, Oracle 8.1.6

 

[ka4niv]

Re: \"Table.Fetch Single\" Gets No Data

Thanks Don ...

However, our users are spoiled - they expect a little more info than "Error!" to show up on the screen.

Oh well, we will keep digging away at it.

Thanks!

Maurice

ES:AS400 SP14 DEP:NT 4.0