PC SOFT

FORUMS PROFESSIONNELS
WINDEVWEBDEV et WINDEV Mobile

Accueil → WEBDEV 2024 → Composite Key Native access
Composite Key Native access
Débuté par TODD ( Beaulieu of A, 04 déc. 2012 18:53 - 1 réponse
Membre enregistré
16 messages
Posté le 04 décembre 2012 - 18:53
I am using a joined logical over 2 physicals on an AS400. I have a composite key defined as company + customer + customersuffix defined as thecompositekey. I am trying to retrieve a record from the file using
hreadseekfirst(file,thecompositekey,[company,customer,customersuffix])
and do not get a hit on the file although I know that the record is in the file for that key and can see it using sql. It simply is "not found". does anyone have an Idea about what might be causing this problem. Thanks in advance.
Membre enregistré
16 messages
Posté le 11 décembre 2012 - 16:11
I received word from an associate that to check the analysis. The file had in the analysis has to match exactly to the key, at least in this circumstance. I now hits the file and pulls the records.