Sorry I just replied in the wrong thread. Here is my reply again
Thanks. Its very useful to know that I can have several db's open at the
same time. I still have my locked records problem though. I now changed my
program to open all db's at the start and close them in the end. This works
great except when I have to do the cross db comparison. This is what I do
- At startup I open all the db's
Inside a function I do the following three things
- I use DmQueryRecord to fetch a record from db1 and unpack it into a
structure
- I then iterate through records in db2, using DmQuery record to fetch each
record. I unpack them into a structure as I iterate through
- In each iteration I use StrCompare to compare db1struct.fld with
db2strct.fld
- I close all db's at program exit
When i exit the program I get the locked/busy records message. Why is the
busy bit set when I am only querying from the db? How should I go about
comparing fields in the 2 db's?
>From: Steve Mann <[EMAIL PROTECTED]>
>Reply-To: "Palm Developer Forum" <[EMAIL PROTECTED]>
>To: "Palm Developer Forum" <[EMAIL PROTECTED]>
>Subject: Re: Locked records
>Date: Sat, 01 Sep 2001 09:58:29 -0700
>
>>Thank you very much for replying to my question. I am a bit
>>confused. Can or can I not have multiple databases open at the same
>>time?
>
>Palm OS applications can have as many databases open at once as they
>like. Conduits can only have one open at a time.
>
>Regards,
>Steve Mann
>--
>Creative Digital Publishing Inc.
>1315 Palm Street, San Luis Obispo, CA 93401-3117
>-------------------------------------------
>805.784.9461 805.784.9462 (fax)
>[EMAIL PROTECTED] http://www.cdpubs.com
>
>--
>For information on using the Palm Developer Forums, or to unsubscribe,
>please see http://www.palmos.com/dev/tech/support/forums/
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
For information on using the Palm Developer Forums, or to unsubscribe, please see
http://www.palmos.com/dev/tech/support/forums/
