>I'm having some trouble with a few of my forms recently. I have several "modules" based on the same class. These include Invoice, order draft, credit notes, etc... Just recently (and I honestly can't think of anything I've changed) _some_ of these have been popping up an open dialog when running in the design environment. The open dilog does not pop up when I compile the program and run it outside the environment. I've traced it to a SET ORDER TO statement but can't figure out why it does that. If I click cancel in teh dialog VFP gives me an error message saying something about not having a table open in the current work area.. If I Cancel on the error message, everything works fine afterwards...
>
>AAhhh ! This is driving me nuts.. Order works just fine(no open dialog), Invoice doesn't, arrival works, credit notes don't...
>And they all look exactly the same to me except for the tables (one being Order, another being Invoice, Credit, etc...)
>
>Help would be appreciated! =:) <- Pulled out most of my hair figuring this out.. Left with a mohawk now.. ;)
Some crazy proposal: could you change table name from 'Order' to 'Orders'. You know, sometimes reserved words can fire calamity inadvertently.
Edward Pikman
Independent Consultant