General information
Category:
Coding, syntax & commands
Title:
Remedial Transaction/Buffering/View Question
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only