Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find field number given it's name
Message
 
 
To
24/10/2007 22:10:36
Victor Chigne
Inteliventas
Peru
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01263411
Message ID:
01263414
Views:
6
= AFIELDS(laList)
lnFieldNo = ASCAN(laList, lcFieldName, -1,-1,1,1+2+4+8)
Why do you need field #?


>Hello. I was trying to locate the field number in a dbf, so I was using:
>
> =AFIELDS(x)
> iTexto= (ASCAN(x,"FIELD_NAME")-1)/18
>
>but it seems that ascan returns the fields in a different order than they are in the DBF definition.
>
>Does anyone know how to get the correct field number?
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform