From: 21.08.1998 16:02 Subject: Re: Possible count solutionTo: INTERBASE@megan.mers.com At 06:47 PM 8/20/98 -0400, Duane Schell wrote: >I played with this for a while and came up with a possiblity. I haven't >played with it long because I have other stuff to do (like my job!) but I >thought I would throw it out for the gurus to consider. > >How about simply including RDB$DB_KEY in your list of fields to be SELECTed? >It may need to be done in a new transaction, but the number seems to be >sequential and hexadecimal. If this is indeed the case, one simply needs to >convert the number to decimal for the record count. No running the query >twice or anything of that nature. > >Does this work? No. The RDB$DB_KEY is not a record counter. It's a three part index, consisting of a pointer page number, an offset on that page, and an offset into the line index on the data page. If you never delete rows, then each new value will be higher than all existing values, but the numbers won't be sequential. Good Luck, Ann ************************************************************************ * This message came from the list servers at http://www.mers.com * * To remove yourself from the list: send an email to listproc@mers.com * * in the body of the message put: unsubscribe INTERBASE * * InterBase Search Engine http://www.mers.com/searchsite.html * * InterBase FAQ http://www.mers.com/faqinterbase.html * ************************************************************************