General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Wierd behaviour in UPDATE SQL
I have a series of sql updates, that worked yesterday. Today, I get a series of assorted errors. I slowly but surley get rid of some to only aqquire new ones.
In the snippet below, I get "Record not locked"
do while num <50
UPDATE repeats SET repeated= getinarow(num) where number = num
num = num + 1
enddo
Thats a new one on me. I've tried RLOCK() on the entire table, no luck.(Alias not found, well, duh, I'm not opening it, I'm running SQL UPDATE)
In the called function (getinarow), which steps through another table, I get "File is in use", even in the first iteration. If I try
USE Yada AGAIN ALIAS LYada
and close the alias before returning, on return I get
"Fatal excpetion code C0000005 at ......(prg file, line number = the update line above)
It all worked fine yesterday!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only