Stored Procedures to edit DB

[serakfalcon]

Hi, the reason for the lack of stored procedures is that it has always been the policy of webERP that it should be possible to port it to other DBMS.

You should use the API for your POS and portal rather than updating the webERP DB directly

Thanks
Tim

There's no inherent conflict between stored procedures and porting, if you abstract the procedures behind a php function (like the API) and make that load whatever script/procedure is appropriate for the DBMS in use you don't even have to worry about it.

As it stands, the portal could potentially use the API but the other existing software can't.