S
springhill23
Hi,
I'm trying to port the following to access (run through OLEDB) and I
keep getting an error stating "Syntax error (missing operator) in query
expression"
update sometable set aux = x.id
from
(select id, Nz((select top 1 id from sometable b where b.parentid=0
and b.id > a.id) - 1, 99999) nextid from sometable a where parentid=0)
x
where sometable.id between x.id and x.nextid
Any thoughts? It works under SQL Server fine.
I'm trying to port the following to access (run through OLEDB) and I
keep getting an error stating "Syntax error (missing operator) in query
expression"
update sometable set aux = x.id
from
(select id, Nz((select top 1 id from sometable b where b.parentid=0
and b.id > a.id) - 1, 99999) nextid from sometable a where parentid=0)
x
where sometable.id between x.id and x.nextid
Any thoughts? It works under SQL Server fine.