Re: Ways to clear a lookup table.

[KBLUMEN@SEARS.COM]

You could create a unique lookup table name within the loop with each iteration
by doing something like this:
let #num = 0
while 1

        do Get-Lookup-Where-Clause
        do Build-LookupTable-ABC (in this procedure concate the lookup table
name with num)
        do Other-Things
        add 1 to num
end-while




 (Embedded
 image moved   *Haixiang Yee <hyee@SMTPGW.ARMS.OHIO-STATE.EDU>
 to file:      01/07/2000 10:01 AM
 pic32406.pcx)




Please respond to sqr-users@list.iex.net

To:   SQR-USERS@list.iex.net
cc:    (bcc: Kimberly Blumenberg)
Subject:  Ways to clear a lookup table.




Hi,

I have a program that builds a lookup table through each
iteration under different criteria.  Apparently, the table
does not get cleared each time you rebuild it based
on different criteria.  In fact, it produces an error
if I try to build it a second time.  Its there ways to get
around this?

For example:

while 1
        do Get-Lookup-Where-Clause
        do Build-LookupTable-ABC
        do Other-Things
end-while

It would error out during the second iteration of the loop.

Thanks,
-Hai

pic32406.pcx