>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