Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remedial Transaction/Buffering/View Question
Message
From
18/03/1998 18:52:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Remedial Transaction/Buffering/View Question
Miscellaneous
Thread ID:
00085516
Message ID:
00085516
Views:
75
I have an updateable, parameterized view that I insert a record into:

INSERT INTO cuecards!cueCards (cue, phrase ) ;
VALUES ( this.parent.card.Value, oKey.Value )
BEGIN TRANSACTION
IF TableUpdate(.T., .T., 'cuecards' )

The table's ID field has a default value of GetID(). The function executes at that TableUpdate (not surprising), but when I look at the view's ID field (this is the primary key field), there's no value assigned. However, by the time I close the form, the field does have the value, okay.

So, obviously, the view doesn't get refreshed with the table values. Obvious now, anyway. (Hey, I'm a beginner with views :-). How
can I requery the view? Or is this just basically the wrong way to go about using views?

TIA
Next
Reply
Map
View

Click here to load this message in the networking platform