Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wierd behaviour in UPDATE SQL
Message
From
02/07/2002 15:33:00
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00673655
Message ID:
00674672
Views:
20
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.
Previous
Reply
Map
View

Click here to load this message in the networking platform