Page 1 of 1

Script to create XXXX Qty. New Records

PostPosted: Thu Oct 30, 2008 8:31 am
by jim shelton
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

PostPosted: Fri Oct 31, 2008 7:47 am
by John Sindelar
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,