Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Alias
Message
From
13/11/2006 12:24:51
 
 
To
13/11/2006 12:16:42
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Alias
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01169200
Message ID:
01169215
Views:
7
>>>>How the heck do I remove an alias from a free table?
>>>
>>>Removing an alias? What do you mean?
>>>Cetin
>>
>>I have a free table named 'Groveall'
>>I assigned an alias to it in my app. eg - >> Use Groveall alias LocalCrime
>>
>>Whenever I try to access the groveall table from the command box I get an error unless I open it using the name plus the alias as indicated above. With the alias used I cannot add the table to the database, which is what I want to do. So, if I can remove the need for the alias, I can add the groveall table to my database.
>
>Aliases are not permanent assignments. I think you mean you get an error like "table is in use", "alias in use" etc.
>
>use in 'LocalCrime' && closes the table with alias LocalCrime
>
>Adding to database is one time job.
>
>close data all
>open database myDatabase
>add table groveall
>
>Cetin

No luck yet. I did exactly as you instructed, but I get this message "Alias LocalCrime is not found". I suppose I could delete the table and create a new one in the database.

It's almost bed time in Turkey.
I ain't skeert of nuttin eh?
Yikes! What was that?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform