Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement