We did some testing and updating ANY table clears the cache, even an update to a temporary table!
Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Wednesday, March 30, 2011 10:09 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CSV and Null unload question Bob: I'm going to keep your solution in my notes! Karen Close! However double quotes popped up using the CSV option. Example using the Gateway Export CSV with Blank_if_zero on "IN","661","No",100,,,,,,"$28.39",,,,,,,"100016842","THEHOMEDEPOT", However, I was able to get it to work using Gateway Export TAB with Blank_if_zero and SEPARATOR , options. IN,661,No,100,,,,,,$28.39,,,,,,,100016842,THEHOMEDEPOT, This big box store is very particular and the format has to be exactly as they dictate. A pure comma separated file with no quotes, no null characters, etc. Thanks for the input, -Bob
