Bill,

I'm not sure, do you still have a problem or is everything solved?

Do you have the creation of the table in the OPEN or the INIT of the form?

If you put it in the INIT method I can't understand why your current
workaround should be needed?

But probably I'm missing some thing.

Anders

On Mon, 13 Feb 2006 09:09:08 +0100, "Anders Jonsson"
<gt3TakeThisAway (AT) bredband (DOT) net> wrote:

What I have is working fine. I was just reporting what I had done to
solve the problem.

It's in OPEN, but previous suggestions pointed out that doing it in
INIT can also create a problem. I don't recall now what it is, but I
chose to avoid the possibility.

One possible problem with creating the table in INIT is that I
couldn't open the form for design unless the table exists. With my
current design, I can.

Probably not.

Bill

OK

Yes, but you only need to run the form once. I ofthen create temporary
tables in the INIT, especially when working with an SQL-backend, and I don't
encounter any major problem with it.

Good you got it working.

Anders

On Mon, 13 Feb 2006 13:59:34 +0100, "Anders Jonsson"
<gt3TakeThisAway (AT) bredband (DOT) net> wrote:

Not true. The form has function other than just creating the table.
The form is an aid for solving Sudoku puzzles. It does the
bookkeeping for you, but doesn't solve it for you. The table stores
partial solutions for later attempts at solving.

Bill

OK, I can't really picture a situation where creation in OPEN *will* work
and a creation in INIT will *not*. Anyway the important thing is that you
found a solution that works for you.

Anders

On Tue, 14 Feb 2006 02:01:36 +0100, "Anders Jonsson"
<gt3TakeThisAway (AT) bredband (DOT) net> wrote:

Oh, I think it would work fine in INIT. I just want to avoid having
the table be in the data model.

And I learned some more about Paradox in the process. Thanks to all
for the suggestions.

Bill