Information générale
Catégorie:
Codage, syntaxe et commandes
Brenda,
If this is the second message, please disregard. I was previewing my last response, and I don't know if it sent it or not.
Check out the SQL Update function. It allows you to set values from one table to another very quickly. You can't use an INNER JOIN, as you can in VB, but you can substitute a SEEK() function in it's place.
It would look like this :
UPDATE table1 ;
SET table1.value = table2.value ;
WHERE SEEK(table1.ID, 'table2', 'table2.index expression')
You add any values to the SET statement, as in any SQL statement. It is very fast. Also, if you don't set the index, and it exists, FoxPro will use the index quoted. If you don't add the index expression, it will use the current index.
Brad
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