Packing the table had no effect. Error still occurs.



>>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?