Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ASCAN to be precise
Message
From
29/07/2001 13:03:38
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00536993
Message ID:
00536999
Views:
8
>>In an array, I have a definition of the fields of my table. So, the first row contains all the field names. When I use ASCAN to find a specific field name, it will locate the proper row. However, assuming I want to search for field name NOM and that I have another field NOMEMBER which is placed before NOM in the array, NOMEMBER will be found before NOM. How can I force ASCAN to be precise?
>
>I guess you are talking about VFP 6 because in VFP 7 ASCAN has a parameter to control exact comparison.

Yes, it is VFP6. Good to hear that VFP7 will take care of that.

>1. When You create array pad field names to the MAXLEN and than ASCAN(myarray, PADR(filedname, MAXLEN))

Well, the array is created with AFIELD, so it can't be applied.

>2. Write FOR loop to scan thru array and do exact comparison using == operator.

What I did was to add SET EXACT ON before ASCAN and SET EXACT OFF after.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform