Normal Topic Add Data only in Update Modus. (Read 825 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Add Data only in Update Modus.
May 20th, 2009 at 11:48am
Print Post Print Post  
Hello!
I would like to produce in advance for example  10000 records in a customer form.
So this file have only ascending customer number and the addition of new customer data will can be entered only in search mode.
How can i generate these 10 0000 records?  Using a mussupdate?

Your help is very much appreciated and Thinks.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: Add Data only in Update Modus.
Reply #1 - May 20th, 2009 at 1:24pm
Print Post Print Post  
Hello Amor,
Do you have programming in place that automatically assigns a customer number?
If so, which event do you have it in?
  
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Add Data only in Update Modus.
Reply #2 - May 20th, 2009 at 4:04pm
Print Post Print Post  
Hello Ben,

i do not want automatically assign a Order number.
I'd like 10 0000 records have only a serial number. So i can find such as no 8889 search and fill other fields to that Order Number.

I must admit, it is a little exotic idea!
Since we customers preprinted labels (1 through 10000) offer, assigns each customer one of  these numbers whenever he has an order for us.
So all these numbers is unique and between 1 10000 and every order gets a these numbers.

I'd like 10 0000 records have only a serial number. So i can find such as no 8889 search and fill other fields to that Order Number.


Thanks.

  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ben
Lantica Support
*****
Offline



Posts: 218
Joined: Apr 7th, 2005
Re: Add Data only in Update Modus.
Reply #3 - May 20th, 2009 at 5:03pm
Print Post Print Post  
Amor,
You can run the following Mass Update in Add Data Mode from the Global Code element. This Mass Update will generate 10,000 records numbered from 1 to 10,000.

GLOBAL CODE :: Mass Update
Code
Select All
stat sLoop as Int
stat sRecordNumber as Int
	sLoop = 1

	While sLoop <= 10000
	{
		sRecordNumber = @CreateNewRecord()
		FormFieldValue(@Layout, "CustomerNumber", sRecordNumber,sLoop)
		sLoop = sLoop + 1
	}

 

  
Back to top
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Add Data only in Update Modus.
Reply #4 - May 20th, 2009 at 8:23pm
Print Post Print Post  
Excellent! That helped me get it.

Thank you Ben.
  

Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged