SELECT cart + FROM team t1,rig t2 + WHERE t2.horseid=t1.horseid + AND cart LIKE '...
My every-day, I'm afraid Bruce -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Albert Berry Sent: Thursday, May 09, 2013 9:10 AM To: RBASE-L Mailing List 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
