Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
NewID() working randomly
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254709
Message ID:
00255026
Views:
24
>>>Is rv_nextkey a view? why not REQUERY() whether or not it was already open?
>>
>>I tried your suggestion, unfortunately it's not working either. I think the problem may be in my startup environment. For some reason, the following statement is doing nothing:
>>
>>USE "eis!rv_NextKey" IN 0
>>
>>It doesn't open the rv_NextKey table, it doesn't return any values.
>
>
>USEing a table doesn't do anything but open it. It doesn't return a value, it doesn't set _TALLY, and it doesn't locate a record.
>
>_TALLY is only set by SQL statements (or views, which use SQL behind the scenes).
>
>To get a value from the table, you first have to locate your record, and then assign the value of a field to a variable.

Ok. (I'm still learing how all this works, thanks for being patient!)
In my case, rv_NextKey is a parameterized view. If I provide a parameter and issue the USE statement, it should open the table (er, I mean view), and will have 1 record in it, right? Then all I have to do is set my return value = to the current rv_NextKey.NewIDvalue.

What I meant above when I said the USE statement wasn't doing anything, was that after issuing the USE statement, if I look to see what the current ALIAS() is, it's *NOT* rv_NextKey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform