Just a thought...Is there ever a circumstance where there are too many rows being retrieved based on a select statement. This cause the program to lock up.
Gary Sent from my Samsung Epic™ 4G Touch -------- Original message -------- Subject: [RBASE-L] - Re: Cursor ideas? From: [email protected] To: [email protected] CC: I mentioned in one of my earlier emails that I did turn it into a permanent table and it still locked up. It was the first thing I suspected and tried... Karen In a message dated 8/10/2012 3:28:36 PM Central Daylight Time, [email protected] writes: Hi Karen, Since you are copying the database to a local drive, why not use a permanent table instead of a temp? If it’s a memory problem, this will make it go away. Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251
