I've used syntax like the example below, but am getting the following error in ElevateDB
and I'm not quite sure why:

Error:
ElevateDB Error #700 An error was found in the statement at line 3 and column 1 (Expected
end of expression but instead found from)


Update Statement Sample:
update tDepts
set tDepts.intCorpId=tCorps.intCorpId
from tDepts
inner join tDepts on tDepts.idCorpId=tCorps.idCorpId

Does ElevateDB use a different syntax?

James

A reply from Tim to me (in the beta ng)


<< I get an error 700 with the syntax below.
update techniquesdocs T set _onDisk = True
from techniquesdocs T
join diskdocs D on T._Path = D._Path

Assuming its not a bug what's the correct syntax anyone. >>
A correlated sub-query will do what you want:

update techniquesdocs T set _onDisk = True
where T.Path=(SELECT D.Path FROM diskdocs D WHERE D._Path=T._Path)


Roy Lambert [Team Elevate]

Thanks Roy for this and all your other reply posts. I definitely appreciate the efforts.

Yechh on the syntax, but better than not being able to I guess



jr

James

>Yechh on the syntax, but better than not being able to I guess

My response to Tim was along the same lines

Roy Lambert [Team Elevate]