Normal Topic @number (Read 1261 times)
jyellis
Full Member
Members
***
Offline


No personal text

Posts: 114
Location: Dallas-Fort Worth Area
Joined: May 19th, 2003
@number
Mar 14th, 2005 at 7:15pm
Print Post Print Post  
I have put this on
element:Key Number5
evit: on form exit

Key Number5 = "CATX" + @right("00000", @str(@number) +5)


But after I save; each new record has CATX00000 in the Key Number5 field

What am I doing wrong?
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: @number
Reply #1 - Mar 14th, 2005 at 7:45pm
Print Post Print Post  
I believe the code you are looking for is,

Key Number5 = "CATX" + @right("00000" + @str(@number), 5)

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged
 
jyellis
Full Member
Members
***
Offline


No personal text

Posts: 114
Location: Dallas-Fort Worth Area
Joined: May 19th, 2003
Re: @number
Reply #2 - Mar 14th, 2005 at 7:50pm
Print Post Print Post  
I get an error in programming when I add the comma before the +5 like you did.
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: @number
Reply #3 - Mar 14th, 2005 at 8:06pm
Print Post Print Post  
Remove the plus sign from in front on the 5, so that your code looks like the code I posted above.

-Ray
  

Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
IP Logged