Thanks for the info Roger. Since this is a static list of words and definitions that I control, I should be able to access a record using the index of the record and then from there be able to pull the definition in to a text field?
I had started creating this without a db and had gotten too many words/definitions and it would not link... So I thought, lets look at the database route. I also saw multi segment option too... is that advisable instead of the db route? Looking for guidance. This is a static list of words that I would build on the desktop to make the PDB and the hand held version would simply be a hand held definition reference. Maybe something like this exists in an example, and I could stop reinventing the wheel :) If anyone knows of something like this, please advise Thanks Dean-O --- Roger Stringer <[EMAIL PROTECTED]> wrote: > At 04:15 AM 10/16/2007, you wrote: > >Subject: Re: DB question, searching > >From: r r <[EMAIL PROTECTED]> > >Date: Mon, 15 Oct 2007 17:54:33 -0700 (PDT) > >X-Message-Number: 5 > > > >Thanks for the idea... to see if I understand this > >correctly, mainly the index counting in the PDB... > is > >the first record in the database index zero or one? > > > >I have also read about unique Id and index. are > these > >the same thing or different? > > Indexes start at zero and are dynamic, so if you > insert a record in > the middle of the file (which you can do!) then the > index numbers > beyond it are incremented by one. Indexes are also > UInt16. > > Record ID's, which are UIn32, uniquely identify each > record and don't > change, except if a file is restored by HotSync. > > But a warning... You should avoid high record > counts! Although you > can have 64K records, you should avoid getting > significantly over > 10K. If you need more records then start treating > each PDB record > as a block and put multiple actual records in each > block. > > > Roger Stringer > Marietta Systems, Inc. (www.rf-tp.com) > > > -- > For information on using the ACCESS Developer > Forums, or to unsubscribe, please see > http://www.access-company.com/developers/forums/ > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- For information on using the ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/
