I am trying to run a sql query to a topspeed db using odbc driver 5.05 however it would appear that it runs into infinite update loop - can anyone shed some light on this please?
table: eventlog
row: guid CHAR(16), userid CHAR(10), date INTEGER(10), time INTEGER(10), type CHAR(1)
update eventlog set time=time+360000 where date=78446 and userid='1111' <-- This runs into infinite update loop
update eventlog set time=time+1 where date=78446 and userid='1111' <-- This also runs into infinite update loop
update eventlog set time=time+0 where date=78446 and userid='1111' <-- This updates 4 rows which is correct
Is there anything that I have missed?
table: eventlog
row: guid CHAR(16), userid CHAR(10), date INTEGER(10), time INTEGER(10), type CHAR(1)
update eventlog set time=time+360000 where date=78446 and userid='1111' <-- This runs into infinite update loop
update eventlog set time=time+1 where date=78446 and userid='1111' <-- This also runs into infinite update loop
update eventlog set time=time+0 where date=78446 and userid='1111' <-- This updates 4 rows which is correct
Is there anything that I have missed?