sql query: remove leading and trailing double quotes
UPDATE m_product SET name = TRIM(BOTH '"' FROM name) WHERE m_product_id = '1128493' UPDATE m_product set name = replace(name, '""', '"') WHERE […]
Author: Ricardo Malla
idempiere: alter sequence
Update M_Product_ID UPDATE ad_sequence SET currentnext = 1026150 WHERE ad_sequence_id = 114 Update Product PriceList UPDATE ad_sequence SET currentnext = 1026138 WHERE ad_sequence_id […]
idempiere: callout function to customize system
http://www.adempiere.com/Callout I need to create a new Callout and add it to the Markup Field I created
openbravo: process request stopped working
Accting Process, Payment Monitor etc stopped working, so Invoices are not posted and Payment Schedules are not monitored (how long is an […]
openbravo: check los logs
The Openbravo Logs are located in: /opt/OpenbravoERP-3.0/tomcat/logs To change the Log Reporting Settings "Error, Debug, Info, Warn etc" you should go to: […]
ubuntu: connect via webservice
First we need to check that there's a viable connection between the two servers, in my case two ubuntu servers. new […]
sugarcrm: mysql query update contacts
Query 1 Adds Vendedor = 1 To All Contacts that are Joined to a Manufacturer UPDATE contacts INNER JOIN a26_proveedor_contacts_c […]
idempiere: add all roles to admin
It's a pain to add all the roles to the Admin Role (I had to re-create this role because I messed up […]
idempiere: cleaning demo data
The following tables use space on my database and for the use I have for the system I will not use them […]
postgresql: find biggest tables on your database
Excecute the following command on phpPgAdmin on the SQL Tab. SELECT table_name, pg_size_pretty(table_size) AS table_size, pg_size_pretty(indexes_size) AS indexes_size, pg_size_pretty(total_size) AS total_size […]