how to generate records to fill up a table

[Viet Nguyen]

Thank you all.

-----Original Message-----
From: Joe Boyle [mailto:atla38@dsl.pipex.com] 
Sent: Tuesday, March 08, 2005 9:42 AM
To: Viet Nguyen; powerh-l@lists.sowder.com
Subject: RE: how to generate records to fill up a table

The qtp code below should do it.

Can cle
Run n1

Req q1 input limit 100 process limit 100
Acc any_file_with_gt_100_recs
define t_100 int * 3 = 1
Subfile my100 include t_100 subtot

Req q2
Acc * my100
Output Scores add
Item scores_item = t_100
Go

Qdesign is easier using a while loop in the init proc.

Can cle
Screen n1

File scores design

temp t_100 int * 3

Proc init
Begin

Let t_100 = 1

While t_100 lt 101
begin
Let scores_item = t_100
put score reset
Let t_100 = t_100  + 1
End

End

Return

Build


Regards, Joe.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Viet Nguyen
Sent: 08 March 2005 14:01
To: powerh-l@lists.sowder.com
Subject: how to generate records to fill up a table


Hi All,
I have a question:
I have a table named Scores with 1 field Score Inter size 4
How do I use powerhouse to generate 100 records and fill it with values
from 1 to 100 sequentiallly ?
Thank you.


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.