Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Your replace statement is only updating one record (at least in this example), could that be it?
I setup similar code and it works (by correcting the previously noted typo). I do a replace all on one field and all updates occur (using pretty much the exact same code as yours, but using the northwind database employees table).
You can turn on SQL Profiler and run your prg and then check to see what commands are getting to SQL server. If there are multiple records being updated, you should be able to look at the generated SQL update command (in SQL Profiler) to debug why the rows are not getting updated.
>Mark
>
>That's just a typo, as I've cut and paste from my VFP code.
>
>As per the previous posts in this thread, this routine works fine. The problem is that only the 1st record from the SQL cursor can be updated, i.e. the very record in the SQL table. If I select the 2nd/3rd/4th record etc. I cannot update it from VFP.
>
>Regards
>
>Derek
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