After creating data inside a table we run this query
UPDATE BollaRighe set BollaRighe.IMPORTO= '0' WHERE BollaRighe.IMPORTO=''
using EXECUTE function....but not works.
Code is this
move "UPDATE BollaRighe set BollaRighe.IMPORTO= '0' WHERE BollaRighe.IMPORTO=''" to my-query
EXEC SQL EXECUTE IMMEDIATE :my-query END-EXEC
bye
|
If IMPORTO is a varchar type
UPDATE BollaRighe set IMPORTO= '0' WHERE IMPORTO=''
or
UPDATE BollaRighe set IMPORTO= '0' WHERE IMPORTO=null
or
UPDATE BollaRighe set IMPORTO= '0' WHERE BollaRighe.IMPORTO=''
or
UPDATE BollaRighe set IMPORTO= '0' WHERE BollaRighe.IMPORTO=null
|
OK ths works
UPDATE BollaRighe set IMPORTO= '0' WHERE IMPORTO=''
But why i cannot use this
UPDATE BollaRighe set BollaRighe.IMPORTO= '0' WHERE BollaRighe.IMPORTO=''
where I write tablename.field ?
Thks
|
|
Because tablename.field is not standard SQL syntax.
|
But in MSSQL is possible and also in other SQLS.
I table1 has a field CODE and table2 has a field CODE in MSSQL is possible write
select table1.code, tabled2.code from table1 left outer join table1.....
update table1 set table1.code = 100
without errors.
|
|
2019-09-12 supports multiple-table UPDATE statement.
|
|
Ok I'll download last update. Thks
|
Main
webmaster@hxtt.com