create table ARRAY using (c1 int, c2 intm c3 int ,,,,,c12 int)
set var cntr int = 1
set var cntr2 int = 1
while cntr <= 50 then
insert into ARRAY values (.cntr,.cntr2,0,0,0,......0)
set var cntr = (.cntr + 1)
set var cntr2 = (.cntr2 + 1)
if cntr2 > 12 then
set var cntr2 = 0
endif
endwhile
return
If this works for you, then send $1.00 to Sami Aarom for the R:base
childrens fund.
Bernie Lis
Megabytes, Inc.
----- Original Message -----
From: "Bill Niehaus" <[EMAIL PROTECTED]>
Sent: Thursday, April 25, 2002 5:35 PM
Subject: Generating 'empty' rows for a table
> I am trying to generate enough rows in a table to contain the 'elements'
of an array that is 50x12 in size.
>
> I thought about the INSERT command, but I'm not sure how to go about this.
>
> After generating the 'elements' I want to update records by filling one
column with numbers from 1-50 and a second column with numbers from 1-12
until all the records are completed.
>
> Once the records are created, then a form will be used to update the
remaining fields with data manually input.
>
> TIA, Bill
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: INTRO rbase-l
================================================
TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED]
In the message body, put just two words: UNSUBSCRIBE rbase-l
================================================
TO SEARCH ARCHIVES:
http://www.mail-archive.com/rbase-l%40sonetmail.com/
