Re: Ways to clear a lookup table.

[Juan Enrique Muñoz <enrique_munoz@KAIZEN.COM.MX>]

Then, there isnt way to clear the lookup table with a sqr command or with a
option in some sqr command?

-----Mensaje original-----
De: KBLUMEN@SEARS.COM <KBLUMEN@SEARS.COM>
Para: SQR-USERS@list.iex.net <SQR-USERS@list.iex.net>
Fecha: Viernes, 07 de Enero de 2000 10:53 a.m.
Asunto: Re: Ways to clear a lookup table.


>
>
>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
>
>