Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Wierd behaviour in UPDATE SQL
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00673655
Message ID:
00674672
Vues:
19
Well, that seemed to fix it, but still does not explain why it worked for several days with no problems. It all ran well, then a whole series of problems cropped up, mostly with the data environment getting confused.
Thanks.
>I's most likely that problem lies in the getinarow() function code or it effect on UPDATE command. Try first to seprate the getinarow() function execution from UPDATE command.
FOR lnNum = 1 TO 50
>  lnRepeats = getinarow(lnNum)
>  UPDATE repeats SET repeated = lnRepeats where number = lnNum	
>ENDFOR
Notice that FOR loop is equivalent of yours DO WHILE construction.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform