Normal Topic Export Problem mit Inital Caps (Read 575 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Export Problem mit Inital Caps
Jan 30th, 2014 at 1:29pm
Print Post Print Post  
Hello!
When I export a data record with a first name field (custom format Inital Caps) i GET  the first name small written!

Why?

Thank you for the help.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
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: Export Problem mit Inital Caps
Reply #1 - Jan 30th, 2014 at 6:05pm
Print Post Print Post  
Hello Amor,

The Display format just controls how the data is displayed in that particular element on the form, it does not change the underlying data that is stored in the field. If you are wanting the data to be stored in Initial caps, you will want to use programming to force the data to be Initial Caps.

-Ray
  

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


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Export Problem mit Inital Caps
Reply #2 - Jan 31st, 2014 at 9:46am
Print Post Print Post  
Thank you Ray.

I set this subroutine on the element exit:

Subroutine InitCaps()
ThisElement = ToUpper(@Lt(ThisElement,1)) + @Mid(ThisElement,2,@Len(ThisElement)-1)
End Subroutine
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
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: Export Problem mit Inital Caps
Reply #3 - Jan 31st, 2014 at 2:19pm
Print Post Print Post  
Hello Amor,

That should work for you, just be sure to call the InitCaps() subroutine also in On element Exit as well. Also you may want to use On Element Change instead of On Element Exit.

-Ray
  

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