Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 4 of 4 total |
>1 table with an update |
Thu, Feb 5 2009 9:38 AM | Permanent Link |
James Relyea | 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? |
Thu, Feb 5 2009 10:15 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Thu, Feb 5 2009 11:53 AM | Permanent Link |
James Relyea | 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 |
Thu, Feb 5 2009 12:11 PM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |