(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › A number with a comma
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic A number with a comma (Read 789 times)
09510951
Member
*
Offline



Posts: 33
Location: Hulshorst, the Netherlands
Joined: Jul 21st, 2008
A number with a comma
Oct 13th, 2008 at 6:04am
Print Post Print Post  
In the Netherlands xlookups with number fields doesn't work. That bug has been reported and will be solved as soon as possible.  A workaround was handed: set the number fields to text fields. I did and I programmed the text field with a programming that I found on this forum:

//this formula works good and avoids losing numers when a record is NOT saved.

if @add then 
{
  if @IsBlank(factuurnummer) then factuurnummer= @ToNumber(@XLookupr(@fn, "99999999", "factuurnummer", "factuurnummer")) +1
}

This results in a number, but places a comma behind the number.

How to solve this?
  
Back to top
 
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: A number with a comma
Reply #1 - Oct 13th, 2008 at 10:46am
Print Post Print Post  
you can use  : @replace(factuurnummer,",","")
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
09510951
Member
*
Offline



Posts: 33
Location: Hulshorst, the Netherlands
Joined: Jul 21st, 2008
Re: A number with a comma
Reply #2 - Oct 13th, 2008 at 3:14pm
Print Post Print Post  
I understand and going to try it
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge