Member Avatar for FlamingBlade

Good day to everybody, new member here! :cheesy:

Using: Delphi 7 with Database Desktop

I've made my tables in Database Desktop, and as soon as I tried seting up Referential Integrity, it did not let me save, which stops me from progressing any further in my project. As soon as I set up the referential integrity, regardless of whether i click "Save" or "Save As", the program gives me the same error:

Invalid filename.
Table C:\Documents and settings\FlamingBlade\Desktop\DD\Orders.DB

An example would be when trying to set up referential integrity between two fields, such as "PhoneNumber" in the Customer Details table and "PhoneNumber" in Orders.

Can anybody please shed some light on this topic? How can I solve this problem or work around it?

Thanks in advance!

Database_Desktop.zip (5.24 KB)
  • 2 Contributors
  • 3 Replies
  • 130 Views
  • 21 Hours Discussion Span
  • Latest Post Latest Post by jwenting
Member Avatar for jwenting

Don't use BDE, it's there for legacy support only.
It's no longer maintained, no longer supported.

Anyway, the error is quite clear. It can't find the file.
Could be because of the spaces in the filename, being a very old program (did I tell you it's there for legacy support only and no longer maintained for the last 7 years or so?) it might not know how to deal with those.

Member Avatar for FlamingBlade

That helped a lot, I moved it to my root C:\ drive and it worked perfectly.

Cant switch to other programs as this is the only one my course provides support for.

Thanks a lot for that!

Member Avatar for jwenting

Delphi 7 provides other means of accessing and creating databases.
If your course insists on you using such ancient technology, demand your money back and enroll in another.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.