Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Record Numbering
#3
joebordes Wrote:Once the record is created there is no way of changing that value from within the application, you will have to go directly into the database.
See if the next SQL and attached image help.

Code:
SELECT `account_no`,substr(`account_no`,1,3), concat(substr(`account_no`,1,3),lpad(substr(`account_no`,4),5,'0')) from `vtiger_account`;
UPDATE `vtiger_account` SET `account_no`= concat(substr(`account_no`,0,3),lpad(substr(`account_no`,3),5,'0')) where {whatever condition};

What does this mean?
Code:
where {whatever condition};
Reply


Messages In This Thread
Record Numbering - polanskiman - 05-20-2014, 10:13 AM
Re: Record Numbering - joebordes - 05-20-2014, 02:14 PM
Re: Record Numbering - polanskiman - 05-21-2014, 04:13 AM
Re: Record Numbering - Ekim - 05-21-2014, 06:11 AM
Re: Record Numbering - polanskiman - 05-21-2014, 07:06 AM
Re: Record Numbering - joebordes - 05-21-2014, 08:41 AM
Re: Record Numbering - polanskiman - 05-21-2014, 08:49 AM
Re: Record Numbering - joebordes - 05-21-2014, 09:06 AM
Re: Record Numbering - polanskiman - 05-21-2014, 09:10 AM
Re: Record Numbering - joebordes - 05-21-2014, 09:21 AM
Re: Record Numbering - polanskiman - 05-21-2014, 09:34 AM
Re: Record Numbering - joebordes - 05-21-2014, 09:40 AM
Re: Record Numbering - polanskiman - 05-21-2014, 09:51 AM
Re: Record Numbering - polanskiman - 05-26-2014, 06:25 AM
Re: Record Numbering - joebordes - 05-26-2014, 08:42 AM
Re: Record Numbering - polanskiman - 05-26-2014, 09:20 AM
Re: Record Numbering - joebordes - 05-26-2014, 09:45 AM
Re: Record Numbering - polanskiman - 05-26-2014, 09:52 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)