Script to create XXXX Qty. New Records

General support questions.
Posts: 68
Joined: Tue Jan 25, 2005 1:45 pm
PostPosted: Thu Oct 30, 2008 8:31 am
I am looking for way to create XXXX number of New Records that matches the QtyToCreate and the Account Number increases by increments of 1 beginning with the StartNumber.

I will need another field in TableB that is a Mod 10 Check Digit of AccountNumber. I believe I have calculation for the Mod 10.

TableA::QtyToCreate (number field)
TableA::StartNumber

TableB::AccountNumber
TableB::CheckDigit

thanks,

Jimbo
JIMBO
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Fri Oct 31, 2008 7:47 am
Hey Jimbo,

Not sure there is enough detail here to help you with the script, but the basics of this kind of thing are to

a) grab any thing you may need from your initial context and set that into $scriptvariables

b) move to the context when you can create records and loop through creating them, using other $scriptvariables or Get ( FoundCount ) as counters so you know when to exit the loop.

Hope that helps,
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: