(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Mass Updating a Number Field to Blank
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Mass Updating a Number Field to Blank (Read 1121 times)
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Mass Updating a Number Field to Blank
Dec 30th, 2005 at 7:48pm
Print Post Print Post  
Good Afternoon:

I would like to mass update a number field, but as you know, if you use "", it converts the value to 0.00.

Is there another way to make it blank altogether ?

Thanks,

Louis
  
Louis Galvao
Back to top
 
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Mass Updating a Number Field to Blank
Reply #1 - Dec 30th, 2005 at 7:54pm
Print Post Print Post  
Solved my own problem by using the trusty programming manual.

CLEAR function works as follows in mass update:

If not @Isblank(JANCOMM) then Clear(Jancomm)

Happy new year to everyone.

Louis Galvao
  
Louis Galvao
Back to top
 
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Mass Updating a Number Field to Blank
Reply #2 - Dec 30th, 2005 at 7:59pm
Print Post Print Post  
Since we are on the Mass Update subject, is there a way to mass update all the layout elements on a TAB without having to specify every single element name in the mass update programming ?

Thanks,

Louis
  
Louis Galvao
Back to top
 
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Mass Updating a Number Field to Blank
Reply #3 - Dec 30th, 2005 at 8:39pm
Print Post Print Post  
Further, when I am trying to save a mass update, it keeps crashing and booting me out of Sesame. 

Initially I thought it was to do with too many fields involved and too much programming.

However, I slimmed it down to seven fields and it keeps crashing when I try to save the mass update spec.  In this case, I ran the mass update successfully before trying to save.

Thanks,

Louis
  
Louis Galvao
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Mass Updating a Number Field to Blank
Reply #4 - Dec 31st, 2005 at 1:31am
Print Post Print Post  
Shouldn't crash. Please send it into Support so we can put it into the debugger, find out why it's crashing on you, and fix it.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Mass Updating a Number Field to Blank
Reply #5 - Jan 3rd, 2006 at 2:44pm
Print Post Print Post  
Initially I thought the crash was a server issue, so I tried it on my local drive.  Again the programming runs but when I tried to save the Mass Update, it closed and locked the application.  I also tried it in the designer and same result.

For what it is worth, I have placed the following programming in my JANCOMM field and selected the additional fields listed below for mass updating:

If not @Isblank(JANCOMM) then Clear(JANCOMM)
If not @Isblank(JANMKTQ1) then Clear(JANMKTQ1)
If not @Isblank(JANMKTQ2) then Clear(JANMKTQ2)
If not @Isblank(JANMKTQ3) then Clear(JANMKTQ3)
If not @Isblank(JANHOLPAY) then Clear(JANHOLPAY)
If not @Isblank(JANVACPAY) then Clear(JANVACPAY)
If not @Isblank(JANBONUS) then Clear(JANBONUS)
If not @Isblank(JANCODE) then Clear(JANCODE)
If not @Isblank(JANOTHER) then Clear(JANOTHER)
If not @Isblank(JANCODE1) then Clear(JANCODE1)
If not @Isblank(JANOTHER1) then Clear(JANOTHER1)

Problem found as we speak !!!  I was selecting all the fields above in the mass update window but only needed to select one. 

A little testing and analysis goes a long way.

Thanks,

Louis
  
Louis Galvao
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Mass Updating a Number Field to Blank
Reply #6 - Jan 3rd, 2006 at 3:02pm
Print Post Print Post  
Thanks to you - found and fixed. The fix will be in the next release. Until then, don't do that.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Louis Galvao
Full Member
***
Offline


"Sufferin' Succatash"

Posts: 265
Location: Canada
Joined: Feb 14th, 2005
Re: Mass Updating a Number Field to Blank
Reply #7 - Jan 3rd, 2006 at 5:15pm
Print Post Print Post  
Mark:

No problem.  Always willing to make my share of mistakes to try and figure out what I am doing wrong.

Thanks,

Louis
  
Louis Galvao
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