Kbase P107442: Unknown value assigned to field if record not previously found with NO-ERROR option
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
4/18/2006 |
|
Status: Unverified
SYMPTOM(s):
Unable to find a record with the NO-ERROR option
Trying to use that record in a FIND with WHERE clause
The FIND returns TRUE if the field an unknown value (?)
This example will show the problem against the sports database:
1.- First, create an order record with ordernum = ?.
2.- Run the following:
FIND FIRST orderline WHERE orderline.ordernum = -1000 NO-LOCK NO-ERROR.
FIND FIRST order WHERE order.ordernum = orderline.ordernum.
MESSAGE AVAILABLE orderline.
MESSAGE AVAILABLE order.
3.- This will show that orderline is not available, but order is.
CAUSE:
This is a know issue being investigated by Development
FIX:
Use the ERROR-STATUS handle to find out if an error is raised or not.