Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Replace alias name with cursorsource
Message
From
24/06/2005 04:39:54
 
 
To
24/06/2005 02:02:10
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows '98
Network:
Windows 98
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01026169
Message ID:
01026190
Views:
15
>Dear Sir,
>
>Is it possible to Replace all Alias names with their relevant CursorSources in DataEnvironment, For example
>
>I have Alias _621 and its CursorSource is 0621 && this is example of one alias
>I want to replace alias name as
>
>replace alias name with alltrim("c")+alltrim(str(cursorsource)) && in case if cursource name is numeric
>replace alias name with alltrim("c")+alltrim(cursorsource) && in case if cursource name is character
>and loop through all alias in dataenvironment of form
>
>After applying command the alias name will be c0621
>
>Please help
THISFORM.DataEnvironment.CloseTables
FOR EACH oCursor IN THISFORM.DataEnvironment.Objects 
  oCursor.Alias = "c"+JUSTSTEM(oCursor.CursorSource)
ENDFOR
THISFORM.DataEnvironment.OpenTables
That would do it... but why would you want to? Why not just set the correct alias name at design time?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform