>When speaking with Microsoft, they suggested avoiding SCATTER MEMVAR, but didn't really have a reason why. I use it all the time with INSERT INTO mydbf.dbf FROM MEMVAR. I have run into an issue where a table may not be updating with the proper information. I was wondering if using the SCATTER MEMVAR command might be causing some oddities. Does anyone know of or experienced any peculiararities using SCATTER MEMVAR with INSERT INTO mydbf.dbf FROM MEMVAR or with APPEND BLANK ; GATHER MEMVAR???? Any feedback is greatly appreciated. Thank you.
>Marcus.
it works fine. they are probably recommending using table / record buffering instead of using memory variables...