Dan, Thanks for the feedback. I've actually gone ahead and changed the form to work with a TEMPORARY VIEW so it removes the APPEND sequence. Works much faster now.
Jan -----Original Message----- From: "Dan Goldberg" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Mon, 2 Feb 2009 10:07:57 -0800 Subject: [RBASE-L] - RE: StaticDB Indexes are stored in the RX3 file. RX2 is data. I would trace it to see which command it hangs up on. Maybe that will help track down the problem command. Dan Goldberg From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Monday, February 02, 2009 9:58 AM To: RBASE-L Mailing List Subject: [RBASE-L] - StaticDB Group, I'm having some intermittant challenges that I have been trying to narrow down. My users occasionally get the message (or something like it) Unable to update RX2. While doing something this morning I got the message (so now I can troubleshoot) The offending form creates a TEMPORARY table and then creates indexes on the temporary table. Since I run with STATICDB ON, could the create indexes be the culprit? Since you normally can't create indexes on a DB with STATICDB ON, I thought you could create indexes on temporary table. However I may be wrong. Jan
