Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select problem
Message
From
06/10/2003 15:44:13
 
 
To
04/10/2003 06:38:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00834920
Message ID:
00835516
Views:
15
>Hi Robert,
>
>In VFP does not have to use alias cursor names of one letters 'A'...'M'
>( you have tons of problem).
>
>Then you can use this ( from table list is mapped to C,D,E,...):
>
>select RECNO('C') arclientRecno,arclient.name,arinv.mnt from arclient,arinv into cursor bob
>
>
>
>select RECNO('D') arinvRecno,arclient.name,arinv.mnt from arclient, arinv into cursor bob
>
>
> Fabio

No you can't do that. You can not use RECNO() or any other Fox function that requires an alias in a multi-table SELECT. The results would be entirely unpredictable.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform