Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Record Numbering
#2
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};

[attachment=0]<!-- ia0 -->Update_sequence_field.png<!-- ia0 -->[/attachment]


Attached Files Thumbnail(s)
   
Joe
TSolucio
Reply


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

Forum Jump:


Users browsing this thread: 1 Guest(s)