my log
pquery update vtiger_contactscf set cf_1124 =? where contactid=?
pquery parameters [091.353.658-03,9555]
how system open a begin/commint transacion in mysql server?
I need use a select sql command first ?
you only need these lines:
global $adb;
$adb->pquery("update vtiger_contactscf set $field =? where contactid=?",array($cpf,$contato_id));
But seens registry is blocked or some like that
if I forced another id works, but the same ID in edition not working ...
but this is inside the validation?
what are you trying to update there? That doesn't make any sense, the information hasn't even been saved yet if you are creating and it will get overwritten anyway when they save
I wish put a mask in field
if number input is 99999999999 i wish write in field 999.999.999-99
understand
the validation event happens before the system save doesn't it?
I can substitute a value in some current field for a system update get there with a mask ?
i'm having contact with the code now
but from what I saw it is well standardized and the functions are shared between modules
Field mask is a very common problem that directly affects database queries
Record only numbers, or record with mask, both cases have advantages and disadvantages
But the worst case scenario is having part numbers and only part mask
The ideal solution would be for the layout editor to include the mask and fields to be just number in the database, I think
I means, my first idea is write in table number and mask together
But in this case, SQL command not will be working or need be informed for end user two ways, one without a mask and another with mask, and this is not good ...
that "groupid" groups the conditions together it has nothing to do with the user groups inside the application
business maps, as global variables are both group and role based