[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

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