IO Status and Error code descriptions

[Don Freeman]

I'm trying to find a reference to what the desrciptions for numeric codes returned to the SV File_IO_Status and the SV Error_Status varibles are. The so-called online help has not coughed up any pointers and forget about those user "guides" that came with the software. Even Googling has turned up nothing. Anyone out there know where this info can be found? Thanks, Don Freeman.

 

[cbruce]

See jdekdfn.h in you system\include directory:

#define ER_SUCCESS 0L
#define ER_WARNING 1L
#define ER_ERROR 2L
#define TABLE_NOT_OPEN 3L
#define TABLE_ALREADY_OPEN 4L
#define ERROR_DETAILS_AVAILABLE 6L
#define RECORD_LOCKED_BY_ANOTHER_UPDATE 5L

Have fun!

 

[Don Freeman]

>#define ER_ERROR 2L

So if I am getting an IO_Status of 2 on a Fetch Single operation then all that tells me is that there was an error on the fetch? Is there a way to narrow down the error type a little further, or does it always mean that the record was not found? If so that may have been a better constant name then just "ERROR".

In other words does:
"If SV File_IO_Status is equal to CO ERROR"
always really mean:
"If Record Not Found"?

Thanks,
Don

 

[cbruce]

Getting an ER_ERROR usually means no record found. It is within the realm of possibility that the DB went down in the time it took to select the record and then fetch it.

Bottom line, ER_ERROR is what you use to test if the fetch returned no records...