Information générale
Catégorie:
Codage, syntaxe et commandes
Steven
>I am having troubles. I have two character fields in a table. I have created an index called pcloc (PadR(field1 + " " + field2,24,' '). In code I use Select myTable, Seek(PadR(variable,24,' '). I feed the variable with aknown record value and I still get not found. What am I doing wrong?
1. Is LEN(field1) + LEN(field2) < 24? If not, increase your pading length.
2. Is variable the concatenation of two variables that are previously padded to have the same lengths as field1 and fiel2? If not, ensure that the string format is identical to the contatenation of the fields.
3. Is pdloc the active tag? If not, try Seek(Padr(variable, 24, ' '), 'MyTable', 'pcloc') instead.
4. Is your string in same case (upper or lower) as your tag?
Daniel
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement