The Google search "elevatedb update from another table"
leads to

https://www.elevatesoft.com/manual?action=viewtopic&id=dbisam4&product=delphi&version=7&topic=update_statement

where an example:is given:

UPDATE orders SET ShipToContact=Customer.Contact
FROM orders LEFT OUTER JOIN customer
ON customer.custno=orders.custno

which yields a syntax error at "FROM", and which actually requires an embedded (Select...)

Gregory,

Got it, thanks very much.

Tim Young
Elevate Software
www.elevatesoft.com

Gregory,

I double-checked that link, and it's referring to the DBISAM 4 manual, hence the issue.  I'm not sure *why* Google is showing this in the results, but it's pretty common for Google to substitute keywords or leave off keywords, if it thinks that the search results will still be relevant.

Tim Young
Elevate Software
www.elevatesoft.com

Tim also,
 https://www.elevatesoft.com/manual?action=viewtopic&id=edb2&product=delphi&version=6&topic=Publish_Unpublish_Databases
 
  MySession.Execute('UPUBLISH DATABASE "MyDatabase"');

Should be:
  MySession.Execute('UNPUBLISH DATABASE "MyDatabase"');

You forgot a "N"!

Michael,

<< You forgot a "N"! >>

What ?  You've never UPUBLISHED a database ?

It's fixed, thanks.

Tim Young
Elevate Software
www.elevatesoft.com

<< What ?  You've never UPUBLISHED a database ? >>

lol!