DelphiFAQ Home Search:

Having a generator generate a string (00001) instead of an integer (1)

 

commentsThis article has not been rated yet. After reading, feel free to leave comments and rate it.

Question:

How to do my generator generate '00001' and not 1? I want my generator to generate a string representation of a number with leading zeroes.

Answer:

InterBase does not have a lot of string functions. You could either write a user-defined function (UDF) - the manual provides an example for a basic string function implemented as an UDF. The downside is that you're going platform specific then.

Or you could use write some (slower) SQL code in your trigger:

I = gen_id(MYGEN, 1);
S = cast(I as varchar(6));

     if (S like '_') then
  S = '00000' || S
else if (S like '__') then
  S = '0000' || S
else if (S like '___') then
  S = '000' || S
else if (S like '____') then
  S = '00' || S
else if (S like '_____') then
  S = '0' || S;


Content-type: text/html

Comments:

2012-06-05, 21:34:13
anonymous from China  
<strong> http://www.coachout..strong> <a href=' http://www.coachout..g>Coach Outlet Online</strong></a><br />
<strong> http://www.coachfac..strong> <a href=' http://www.coachfac..g>Coach Factory</strong></a><br />
<strong> http://www.myloveco..strong> <a href=' http://www.myloveco..g>Coach Outlet Online</strong></a><br />
<strong> http://www.buyincoa..strong> <a href=' http://www.buyincoa..g>Coach Outlet</strong></a><br />
<strong> http://www.cheapcoa..strong> <a href=' http://www.cheapcoa..g>Cheap Coach Handbags</strong></a><br />
<strong> http://www.coachfac..strong> <a href=' http://www.coachfac..g>Coach Factory Outlet</strong></a><br />
<strong> http://www.buycoach..strong> <a href=' http://www.buycoach..g>Coach Outlet Online</strong></a><br />
<strong>www.coachoutletonfactory.net</strong> <a href=' http://www.coachout..g>Coach Factory Outlet</strong></a><br />
<strong>www.coachoutletonline4you.us</strong> <a href=' http://www.coachout..g>Coach Outlet Online</strong></a><br />
<strong>coachfactoryoutletq.net</strong> <a href=' http://www.coachfac..g>Coach Factory</strong></a><br />
<strong>gotocoachoutlets.net</strong> <a href=' http://www.gotocoac..g>Coach Outlet Online</strong></a><br />
2012-11-12, 02:07:04
coach001 from United Kingdom  

 

 

NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.
 

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: