Re: How do I get this query to work?



On 14 Jul 2005 12:14:10 -0700, "Ed Prochak"
<ed.prochak@xxxxxxxxxxxxxxxxxx> wrote:

[snip]

>But for other things, ID fields are often used just like record numbers
>for other entities in the databse. Look at some of the questions asked
>of the DB. If they aren't used that way, why not have an auto ID
>generator use a sequence of random numbers? would you object to that?
>Why?

It takes longer to generate a number since it can not be presumed
that the ID number is not already in use. With an ordering, that can
be assumed (though I think it not a good idea).

Sincerely,

Gene Wirchenko

.



Relevant Pages

  • Re: Error 1308 comparing strings
    ... It worked fine for me under VFP 6. ... Gene Wirchenko ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Requery(viewname)
    ... in a loop. ... Gene Wirchenko ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Switching to .NET from FoxPro
    ... >I am not sure I have 10 features but I will try: ... Gene Wirchenko ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VFP7 wont run
    ... Scary Hallowe'en for you, Ook. ... Gene Wirchenko ... Prev by Date: ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Base Normal Form
    ... will not get it in any particular order unless you specify the order. ... If it does matter, then specify the ... Gene Wirchenko ...
    (comp.databases.theory)