This UPDATE ran ok in DBISAM:

UPDATE MACLIENT C SET SIGLAVIACOD = S.CODIGO FROM MACLIENT C INNER
JOIN MASIGLAV S ON C.SIGLAVIA = S.SIGLA WHERE C.SIGLAVIA IS NOT NULL;

while in EDB needs to be changed to

UPDATE MACLIENT C SET C.SIGLAVIACOD =  (SELECT S.CODIGO FROM MASIGLAV
S WHERE C.SIGLAVIA IS NOT NULL AND C.SIGLAVIA = S.SIGLA);

The DBISAM to EDB changes say: "The FROM clause is no longer
supported. ElevateDB can use correlated sub-queries in the UPDATE
values and/or WHERE clause."  

Does mean "ElevateDB *can use* correlated" "must use"? or there are
more ways to do it? and more efficient ones?


Tiago Ameller
tiago put_an-a-_in_a_circle sistemasc.net
Sistema, S.C.

Tiago,

<< Does mean "ElevateDB *can use* correlated" "must use"? or there are more
ways to do it? and more efficient ones? >>

The text was essentially saying *why* the joins in the FROM clause, which
are non-standard, are no longer necessary, i.e. EDB can use correlated
sub-queries instead.

--
Tim Young
Elevate Software
www.elevatesoft.com