Feeling your pain.. For what it's worth, I never "drop" the tables in my on before design actions. Many times I have the temp table out there with the data I want in it, so it's annoying to have it dropped. I just put the "create temp table" in there... if it already exists it just throws an error.
Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, May 9, 2013 11:11 am Subject: [RBASE-L] - Today's DUH moment I just spent 15 minutes trying to figure out what was wrong with a form I created using R:Azzak's marvellous "click to switch sides" form with a view and a temp table. I opened the form in design mode and got error 2038 "Table does not exist". My On Before Design action created the table. It dropped the table first, with error 2038 off. What the heck? Well, DUH - when you create a view that refers to a table that you have not yet created ... So I switched the table and view definitions so the table was there when I created the view ... Just one of those mornings, I guess. Albert
