>When I suspend the code, it's on the SEEK command.
>
>cKey is a variable containing the string "8263 PLUS BNS37LBC10"
>
Perhaps it happened after the INSERT COMMAND. If you PACK this table, would you still have an error?
Also try to use m.cKey instead of cKey.
>
>
>
>
>>Are you sure you're getting an error on the SEEK command and not on the INSERT command?
>>
>>Also is cKey a field from a table or a variable?
>>
>>>I'm getting this error when running this SEEK:
>>>
>>>
>>>
>>>** THIS SEEK LINE CAUSES THE ERROR
>>>** cKey has "8263 PLUS BNS37LBC10" in it
>>>IF !SEEK(cKey,"EQPINSTDF","EID_PSC")
>>>
>>> lnEIDPK = NEW_PK("EQPINSTDF")
>>>
>>> INSERT INTO EQPINSTDF;
>>> (eid_pk,eid_prod_code, eid_shipper, eid_consignee, eid_entered,eid_enteredby, eid_prd_fk);
>>> VALUES(lnEIDPK, cProdCode, womast.wom_loader, womast.wom_consignee, DATETIME(), lcUser, products.prd_pk)
>>>
>>>ELSE
>>>
>>> lnEIDPK = EQPINSTDF.EID_PK
>>>
>>>ENDIF
>>>
>>>
>>>Anyone know why this is?
If it's not broken, fix it until it is.
My Blog