Re: DB question, searching

2007-10-18 Thread Lionscribe
It seems that you have this Palm database thing all confused. The Palm database system has nothing to do with the standard database of Access or the like, other than it is a collection of records. The PdbTools you are using, I believe is meant for the db program, which is a free database program

Re: DB question, searching

2007-10-17 Thread r r
It started as a CSV file and then I converted it to a PDB with pdbtools desktop tool. The csv file was two columns... word and definition. when I run the program in debug mode, with breakpoints, it gets a record at the index I supply but nothing is displayed in the text field for the

Re: DB question, searching

2007-10-17 Thread Roger Stringer
At 04:15 AM 10/17/2007, you wrote: Subject: AW: DB question, searching From: Harald Schlangmann [EMAIL PROTECTED] Date: Tue, 16 Oct 2007 18:18:21 +0200 X-Message-Number: 14 Roger, what is the clue behind the 10k limit? But a warning... You should avoid high record counts! Although you can

Re: DB question, searching

2007-10-17 Thread r r
either. Thanks Dean-O --- Roger Stringer [EMAIL PROTECTED] wrote: At 04:15 AM 10/17/2007, you wrote: Subject: AW: DB question, searching From: Harald Schlangmann [EMAIL PROTECTED] Date: Tue, 16 Oct 2007 18:18:21 +0200 X-Message-Number: 14 Roger, what is the clue behind the 10k limit

Re: DB question, searching

2007-10-17 Thread Phreak OnALeash
[EMAIL PROTECTED] wrote: At 04:15 AM 10/17/2007, you wrote: Subject: AW: DB question, searching From: Harald Schlangmann [EMAIL PROTECTED] Date: Tue, 16 Oct 2007 18:18:21 +0200 X-Message-Number: 14 Roger, what is the clue behind the 10k limit? But a warning... You should

Re: DB question, searching

2007-10-17 Thread r r
Here is the url of the tool I used... http://sourceforge.net/project/showfiles.php?group_id=10524 __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- For information on using the ACCESS

Re: DB question, searching

2007-10-16 Thread Roger Stringer
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

Re: DB question, searching

2007-10-16 Thread Phreak OnALeash
Hi, I meant a general index of all the words in the file (like an index in teh back of a book), sorry. NOT the record's index in the files system... On 10/15/07, r r [EMAIL PROTECTED] wrote: Thanks for the idea... to see if I understand this correctly, mainly the index counting in the PDB...

AW: DB question, searching

2007-10-16 Thread Harald Schlangmann
Roger, what is the clue behind the 10k limit? 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

Re: DB question, searching

2007-10-16 Thread r r
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

Re: DB question, searching

2007-10-16 Thread Phreak OnALeash
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

Re: DB question, searching

2007-10-16 Thread r r
Thanks for the idea... I think I almost have this DB thing working... I have the db open with // get the handle to the record and set busy bit recordHandle = DmQueryRecord(gDatabase, dbIndexNum); now how to I get the text out of this recordHandle? the record consists of the word and then the

Re: DB question, searching

2007-10-16 Thread Phreak OnALeash
Get text with MemHandleLock... gives you all data in the record. On 10/16/07, r r [EMAIL PROTECTED] wrote: Thanks for the idea... I think I almost have this DB thing working... I have the db open with // get the handle to the record and set busy bit recordHandle = DmQueryRecord(gDatabase,

Re: DB question, searching

2007-10-16 Thread r r
It appears as though I have the record, how to I get the text for the second column (if you will, I know there are no columns) but the first thing is the word the second should be the definition. How do I get that definition piece? Is this recordHandle a structure and I can get the second

Re: DB question, searching

2007-10-16 Thread Phreak OnALeash
The record is however you have it structured when it's created :-) What tool did you use to make it? If you made it yourself you should know the structure. On 10/16/07, r r [EMAIL PROTECTED] wrote: It appears as though I have the record, how to I get the text for the second column (if you

Re: DB question, searching

2007-10-15 Thread r r
I created the PDB on my desktop of the words and their definition. How do I get the index? Am I making this too hard? Is the first one index zero or index one? and then they go up from there? Is it a hex index or is the ID or index simply the number 0 or 1,,, etc.? Dean-O --- Phreak

Re: DB question, searching

2007-10-15 Thread Phreak OnALeash
Hi, You;d make the index yourself... This is a little ugly as I can't try it myself (mostly pseudocode): char* index[5] { word1, word2, word3, word4, word5 }; This could be the first record in your database. You can pretty easily go through a list of strings like this and find

Re: DB question, searching

2007-10-15 Thread r r
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? Thanks Dean-O

DB question, searching

2007-10-14 Thread DeanO
Hi all, I am trying to create a vocabulary type program, which has a series of screens that have select triggers on them, which are the vocabulary words. I want to search the database for the description based on what select trigger(vocabulary word) they pick. I have seen there are search

Re: DB question, searching

2007-10-14 Thread Phreak OnALeash
Hi, IMO, you'd ave to roll your own if you wanted to do a text search... In my opinion, it would be easier to keep an index of the vocabulary words and goto that record, directly. On 10/14/07, DeanO [EMAIL PROTECTED] wrote: Hi all, I am trying to create a vocabulary type program, which has a