Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Generating Unique ID
Message
 
 
To
27/11/2001 18:07:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00586682
Message ID:
00586770
Views:
22
>What difference does it matter what alias you open it under? The only thing that matters is the default value function call, and the only thing that matters is that you use a unique value:
>
>getNextID("thisMustBeDifferentForEveryTable--butDoesNotNecessarilyHaveToBeTableNameOrAlias")
>
>I don't see anywhere where you try to select the alias in your getNextID() function, so it should not matter...
>

Here is the call:

lcDBC=cursorgetprop('database',m.tcAlias) && Return the name of owning database

If my table is open under different alias, this line generates an error in SP.
So, I need to know the alias name, under which this table is open. Otherwise, how can I ensure, that if will open the correct NextID table. I'm thinking about renaming NextID into something different (unique per database), so I would not need this complicated code...


>>
>>The problem is, what if I open table under different alias? In default value I have GetNextID('AllFunctions').
>>
>>So, my problem is to find out under which alias AllFunctions table is opened. I'm having brain loss at this moment. How can I find out the alias by fullpath table name?
>>
>>Thanks a lot in advance.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform