Board index » delphi » CD-ROM Database problems

CD-ROM Database problems

What am I doing wrong? I want to develop a database application with a
paradox database on CD-ROM. Whatever I do, I cannot open tables I wrote to a
CD.
I can see and open the tables in de DataBase desktop; also, the Object
Inspector sees the tables for the TTable's tablename property. If I want to
open the table either in design- or run-time, I get the error: "Invalid file
name.."

The funny thing is I CAN open the demo tables on the Delphi 3 installation
CD.
I wonder if the pdoxusrs.lck or paradox.lck files in de dbase directory on
the CD enable me to open the dbase demo data tables?

Could the CD-ROM data format cause problems?

Please help,

Wilfried Visser                        \|/
                       (. .)
 -----------------.oOO--(_)--OOo.------------------
| Wilfried and Annemarie                           |
| Amsterdam The Netherlands                        |
| E-Mail: wvis...@xs4all.nl                        |
| Internet: http://www.xs4all.nl/~wvisser/         |
|                                                  |
| Work:                                            |
|        National Aerospace Laboratory, NLR        |
|                                                  |
|               Wilfried Visser                    |
|               Flight Department                  |
|                                                  |
| Tel: +31 (0)20 5113308       Anthony Fokkerweg 2 |
| Fax: +31 (0)20 5113210       1059 CM  Amsterdam  |
| E-Mail: wvis...@nlr.nl       The Netherlands     |
| Internet: http://www.nlr.nl                      |
 --------------------------------------------------

 

Re:CD-ROM Database problems


Quote
Wilfried Visser wrote:

> What am I doing wrong? I want to develop a database application with a
> paradox database on CD-ROM. Whatever I do, I cannot open tables I wrote to a
> CD.
> I can see and open the tables in de DataBase desktop; also, the Object
> Inspector sees the tables for the TTable's tablename property. If I want to
> open the table either in design- or run-time, I get the error: "Invalid file
> name.."

> The funny thing is I CAN open the demo tables on the Delphi 3 installation
> CD.
> I wonder if the pdoxusrs.lck or paradox.lck files in de dbase directory on
> the CD enable me to open the dbase demo data tables?

> Could the CD-ROM data format cause problems?

> Please help,

> Wilfried Visser                        \|/
>                        (. .)
>  -----------------.oOO--(_)--OOo.------------------
> | Wilfried and Annemarie                           |
> | Amsterdam The Netherlands                        |
> | E-Mail: wvis...@xs4all.nl                        |
> | Internet: http://www.xs4all.nl/~wvisser/         |
> |                                                  |
> | Work:                                            |
> |        National Aerospace Laboratory, NLR        |
> |                                                  |
> |               Wilfried Visser                    |
> |               Flight Department                  |
> |                                                  |
> | Tel: +31 (0)20 5113308       Anthony Fokkerweg 2 |
> | Fax: +31 (0)20 5113210       1059 CM  Amsterdam  |
> | E-Mail: wvis...@nlr.nl       The Netherlands     |
> | Internet: http://www.nlr.nl                      |
>  --------------------------------------------------

Hello,
  Make sure you set the ReadOnly property to TRUE on your TTables.
Also, move thos .LCK file from the Delphi CD to your CD and try it
again.  those directory lock files are needed by the Paradox driver.

 Scott
--
BDE Support:
 http://www.borland.com/devsupport/bde
Delphi Support:
 http://www.borland.com/devsupport/delphi
Common Delphi and BDE Questions and Answers:
 http://www.borland.com/devsupport/delphi/qanda/

Re:CD-ROM Database problems


Quote
>The funny thing is I CAN open the demo tables on the Delphi 3 installation
>CD.
>I wonder if the pdoxusrs.lck or paradox.lck files in de dbase directory on
>the CD enable me to open the dbase demo data tables?

Yes these are special readonly locks

 See TI3104 for details on placing directory locks

http://www.borland.com/devsupport/BDE/ti_list/

--
Brian Bushay (TeamB)
Bbus...@DataGuidance.com

Other Threads