Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Passing field names within variables??
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00134243
Message ID:
00134479
Vues:
10
>>No, it would expect to find a field called lcfieldname in your table. Instead use:
>>
>>x = eval('myTable.' + lcFieldName)
>>
>>
>>>I'm in the process of trying to use a xtab query in a report. The query results are too large for a VFP report. Can I get a field value like this:
>>>lcFieldname = FIELD(lcFNum)
>>>
>>>myTable.lcFieldname = x
>>>
>>>Will VFP recognize the variable as a field name??
>>>
>>>(Boss doesn't want to use Crystal Reports)
>
>Thanx Anyhow Ken,
>
>It won't accept the eval's

Perry, you can always use UDF as generic solution, e.g. you create report field with gettablefield() as field expression, and
Function gettablefield
Do case
Case oApp.reporttype=1
return table1.field1
Case oApp.reporttype=2
return table5.field4
....
Endcase
Endfunc

and why you complain so much about your boss? As far as I see from your replies he/she is great.
Edward Pikman
Independent Consultant
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform