mysql: update or delete with join operators (contacts)
Same as previous post but this time with Accounts instead of Leads. List the Contacts related to the Accounts this employee has assigned: […]
Category: it
mysql: update or delete with join operators
I'm trying to update some records on Table C (contacts.assigned_used), but I have a Join from Table A (leads) and passing through […]
jasper reports: api configuration
http://192.168.1.220:8080/jasperserver/rest_v2/reports/reports/MG/Compras/Compras_Fabricantes_Notes.pdf?Fabricante=3M
java: compare boolean vale
I require this to limit the Print when Expression Field on Jasper Studio. I had some trouble getting the comparison formule, because […]
mysql: query to find "orfan" notes on sugarcrm
The following Query get me a List of the Lines I want to Delete, but I cannot execute a query to Delete […]
pgsql: list and remove triggers
I want to delete directly on the PgSQL database on my OpenBravo application but it has a los of triggers that prevent […]
openbravo: delete physical inventory
I cannot Post "Goods Receipt", I believe there is an error when opening the Physical Inventory. I have created a couple of […]
openbravo: goods shipment not posting
It is not posting because the Costing Algorithm is not working, probably because it is not recognizing the Currency.
pgsql: cannot delete line on table.
This happens when I try to manually delete a record on the Database ERROR: update or delete on table "m_inoutline" violates […]
openbravo: delete goods receipt
I have not found an immediate way to do it. Manually Delete Records from: m_matchpo m_transaction m_inout SELECT m_inout.documentno, m_inoutline.line, m_matchpo.updatedby […]