Line 334:
Line 334:
Those files are converted "on the fly" by the database Dolibarr driver.
Those files are converted "on the fly" by the database Dolibarr driver.
−
There is an exception
+
There is an exception for the SQL "UPDATE FROM":
−
The SQL "UPDATE FROM":
MySQL Syntax:
MySQL Syntax:
Line 349:
Line 348:
</source>
</source>
−
There is no native SQL request "update from" in dolibarr core. But in your module you should do :
+
There is no native SQL requests "UPDATE FROM" in all Dolibarr core. But if you use one in your own code of your module, you should do :
<source lang="php">
<source lang="php">
if ($this->db->type=='pgsql') {
if ($this->db->type=='pgsql') {