Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Michael,
I have posted this over in the VFP area and someone suggested that I try table level buffering instead of row buffering (which actually made the problem worse).
The trigger calls a stored procedure which processes the inserted record(s), updating another table (a summary history table) with values from the inserted record(s).
It seems very odd that the remote view in Fox would have all 1000 records ok, but that the SQL table would be missing records. If the trigger is failing on the back end, wouldn't it cause an update error to be returned to Fox?
Thanks for any help/insight you might have.
Précédent
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