Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Referencing field without alias
Message
From
30/10/1998 12:46:31
 
 
To
30/10/1998 12:09:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00152877
Message ID:
00152912
Views:
19
Thanks for the response. I was just curious if there was any syntax that supported this that I didn't know about. I was in a stored procedure that will work on the current ALIAS() and had a comparison statement:

lcAlias = ALIAS()
IF lcMyVar = &lcAlias..'fcModBy'
.....

wondered if there was a simple way to reference the field 'fcmodby' in the current alias without the Alias in a way that distinguishes it from a variable name.


>>Is there a way to reference a field without specifiying the currently selected alias, something in the flavor of m.Fieldname? I think I've seen this in old Dbase code, just don't know if there is a way to do it in VFP.
>
>You don't need in alias referencing to current table.fields. Also, many commands support IN close to do it in different work areas. However, using alias is the way to make code more readable.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform