Re: a simpler way...?

#1

Hoo boy that one again.

This is a well known thorny problem, with difficulties in any database environment,
not just Paradox. Generating unique keys has been discussed many times on
this board.

See www.rdaworldwide.com and www.thedbcommunity.com for papers and resources
online. Dennis Santoro has a product that manages unique keys.

Getting cMax and incrementing is one of the worst methods known. It is very
slow and gets slower as the table grows, and it will not scale to multiple
users.

-Al.

Kenneth <usenet (AT) soleSPAMLESSassociates (DOT) com> wrote:

Quote:

Howdy,

Using P9 with XP...

I need to have a field in an MRO number entries in sequence.
That is, the first entry gets a "1" and the second gets a
"2" etc.

I don't want to use a autoincrement type because the field
is part of a key.

I could run a query, get a cMax, and increment by one, but
is there a simpler way to do the deed?

Many thanks,
--
Kenneth

If you email... Please remove the "SPAMLESS."

#2

Hoo boy that one again.

This is a well known thorny problem, with difficulties in any database environment,
not just Paradox. Generating unique keys has been discussed many times on
this board.

See www.rdaworldwide.com and www.thedbcommunity.com for papers and resources
online. Dennis Santoro has a product that manages unique keys.

Getting cMax and incrementing is one of the worst methods known. It is very
slow and gets slower as the table grows, and it will not scale to multiple
users.

-Al.

Kenneth <usenet (AT) soleSPAMLESSassociates (DOT) com> wrote:

Quote:

Howdy,

Using P9 with XP...

I need to have a field in an MRO number entries in sequence.
That is, the first entry gets a "1" and the second gets a
"2" etc.

I don't want to use a autoincrement type because the field
is part of a key.

I could run a query, get a cMax, and increment by one, but
is there a simpler way to do the deed?

Many thanks,
--
Kenneth

If you email... Please remove the "SPAMLESS."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: a simpler way...?

comp.databases.paradox comp.databases.paradox

Re: a simpler way...? - 11-07-2008 , 01:57 PM

Re: a simpler way...? - 11-07-2008 , 01:57 PM