InstantDB Project
About InstantDB
Project Mail Lists
Short History
Reporting Bugs
Screen Shots
3rd Party Examples
FAQs

Software
Downloads
Documentation
CVS Repositories
Roadmap
License

About Enhydra.org
Who We Are
News, Articles & Events
Getting Involved
Contact Us

Community
Demos
Contributions
Resources
Case Studies
On The Edge! -NEW-
Commercial Vendors


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: InstantDB: update query error


Shawn

I don't think InstantDB implements joins as part of updates. The best 
you could do you be something like:

update table1 set table1.colA = 
  (select colB from table2 where colB=foo)
where colA=foo

I don't think either SQL syntax is standard.

Pete

----- Original Message -----
From: "Shawn Gorman" <shgorman@mindspring.com>
Date: Friday, March 2, 2001 2:06 am
Subject: InstantDB: update query error

> Could someone give me an example of the correct syntax for 
> updating the values in one table with values from another table.
> They synxtax I use in several other databases, that I thought was 
> standard to all databases is:
> 
> Update table1 set table1.colA = table2.colB from table2 where 
> (table1.ID = table2.ID)
> 
> I get an error that the from was not expected. I have tried ever 
> other possible combination I can think of to make this work with 
> no luck.
> Any help would be greatly appreciated.
> 
> Shawn Gorman
> 
> 
> Also, on a similar note. I sometimes get an illegal mixture of 
> string/numeric but both sides of the = are integers.
> 

-----------------------------------------------------------------------------
To unsubscribe from this mailing list, send email to majordomo@enhydra.org
with the text "unsubscribe instantdb" in the body of the email.
If you have other questions regarding this mailing list, send email to
the list admin at owner-instantdb@enhydra.org.