Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Browse shows unwanted records.
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00262764
Message ID:
00262768
Views:
11
>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.

This isn't what you want to hear, probably, but BROWSE has decreasing functionality in vfp. And I quote from Hacker's Guide:


"BROWSE has no place in applications..." - referring to vfp. "Use grids..."
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform