Very Computer

by **J.D. Cart** » Sun, 19 Feb 1995 06:30:37

I need to be able to keep my table from automatically sorting
itself, until I am finished entering the data & exit the page/form

Any assistance would be very much appreciated

Thanks in advance
JD Carter

by **Kuo-Sheng (Kas** » Wed, 22 Feb 1995 08:52:42

: I need to be able to keep my table from automatically sorting
: itself, until I am finished entering the data & exit the page/form

You need to delete the primary index from the table, then sort it
manually afterwards, and maybe reindex it later.

--
+============================================================================+

|| Pretty good Paradox for Windows Programmer, self-proclaimed Treknologist ||
|| [ the rest of this sig is under construction until further notice... ] ||
+============================================================================+

by **Shlomo Wygod** » Thu, 02 Mar 1995 03:49:19

You may have a look on Flyaway in the manual (pg 445), but it won't help you.

--

Tel: +972 3 5388888, +972 3 5388853 Fax: +972 3 5331617
Mercury Interactive (Israel) Ltd P.O.B. 501, Or Yehuda 60218, Israel
World leader in Automated Software Testing

by **KevinBlu** » Sun, 05 Mar 1995 03:48:51

I you have a keyed table in your DM, the records WILL flyaway to their
sorted locations as soon as you successfully unlock them. There is no way
to prevent this behavior with a keyed table.

My suggestion is for you to use a temporary, unkeyed table while editing
data with your form. Create the temp table as a duplicate of the form's
master table, extract the records you need to edit (if appropriate) into
the temp table, open the form on the temp table, do your thing, and when
finished add the modified records back into the original table.

If you're working in a multiuser environment, you will have to do some
serious consistency checking, but it's fairly easy in a single-user
environment.

In general, though, its best to accept Paradox's way of doing things and
work with it.

Did you know that you can place and link data model tables using secondary
indexes as well as primary keys? That way, the records are still sorted,
but the way YOU want.

Kevin J Bluck

Very Computer

Need to keep table from auto-sorting till done w/ form

Need to keep table from auto-sorting till done w/ form

Need to keep table from auto-sorting till done w/ form

Need to keep table from auto-sorting till done w/ form

Need to keep table from auto-sorting till done w/ form