We are having some issues with retrieving our information into our repeater. The problem is that we populate our repeater from a temporay table in SQL Server 7 that is created when a search command is issued. The information comes out of the main table, goes into the temp table and the repeater populates from that table. Whe we go to do another search the repeater seems to hold the previous information in temporary memory some where and keeps poulating with the first record search after the form is loaded. The only way to see the record is to exit the program and re-load it. The repeater will then populate with the record searched just before exiting. This happens even though the SQL table populates properly.
WHAT ARE WE DOING WRONG? HOW CAN WE DELETE THIS TEMPORARY MEMORY FOR THE NEXT SEARCH??????????
WHAT ARE WE DOING WRONG? HOW CAN WE DELETE THIS TEMPORARY MEMORY FOR THE NEXT SEARCH??????????