Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Browse shows unwanted records.
Hi All!
The following code segment is giving me problems! When the user enters some string, the code takes that string and browses all records which contain that string as the first few characters of the last name. The problem is that other records appear with all asterisks(*). How do I get rid of the asterisks. Note that the aberant behavior only occurs when the program is running. If I run just the locator form by itself from the development environment, it shows only the proper records with no asterisk lines.
IF LEN(ALLT(cLast)) > 0
BROWSE TITLE "Select Name - Then Close Locate Window" ;
FIELDS hist_last :H="Last Name", ;
hist_first :H="First Name", ;
hist_init :H="Init", ;
hist_comp :H="Company/Store/Institution" ;
FOR LEFT(UPPER(hist_last), LEN(ALLT(cLast))) = UPPER(ALLT(cLast)) ;
NOEDIT NOAPPEND NODELETE
IF !EOF()
nRec = RECNO()
ThisForm.Release
ELSE
MessageBox("No selection made.")
ENDIF
ENDIF
TIA!
Tom.
Suivant
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