Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2008 Server
Sergey
The PK field is a unique record ID, set by SQL Server itself, and the 10 records I'm editing all exist, it's purely a read from SQL. VFP runs a stored procedure from SQL Server, along the lines of:
begin
set nocount on;
select * from dbo.MyTable where RecordLive = 1
end
My VFP code performs this stored procedure, returns a dataset, loops through each record in the dataset, modifies data in each record, and then once all modifications have been done to each record the VFP code performs a table update. When you return to SQL you see that the modifications that you've done to record 10 are copied across to records 1-9, rather than 1-9 having their own unique updates.
Précédent
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