Paradox 8 table keeps reverting to Paradox 4 Table !Help! 1

[Eviltwin]

Greetings--
I have a table that needs to have a variety of lookup fields. I created the table in Paradox 8 as a Paradox 7-8 table. Then I assigned all the lookup tables. When I go to save the table I am told that it does not need to be that high a version and it get's saved as version 4.--I am not given a choice here. Then the lookups go away because they are not supported by version 4.

I have tried and tried to make this work. Any ideas out there?
Thanks

 

[Langley]

Add a logical field (not supported in 4) to it when you create it, then restructure it to remove the logical field.

Mac

 

[JoeNg]

Are your look up tables created in Pdox 8 or 4?
If not, make them all 8.

 

[Eviltwin]

Thanks!!
I will try both approaches and respond in case anybody else has a similiar situation.

 

[Eviltwin]

Success! Thanks !
I built all the tables from scratch. Added a logical field to each table and was allowed to save them as Paradox 5 tables. I then used table restrucure to remove the unneeded logical field from the tables. All the lookups work as they are intended. Back to my project.

Thanks again.

 

[footpad]

Eviltwin,

By default, BDE creates Paradox tables at the minimum level necessary to support the structure of the table. If you're not using version 7 contructs, then you'll get an older format.

You can change this by:

1. Opening Control Panel and then starting the BDE Administrator.

2. Clicking the Configuration tab.

3. Choosing the following settings: Drivers | Native | Paradox.

4. When the current settings appear in the right-hand panel, set LEVEL to 7. (It's probably set to 3 or 4)

5. Closing the BDE Administrator and all BDE client applications, including Paradox, Delphi, etc.

6. Restarting Paradox. It should now create version 7 tables by default.

Mind you, this only affects new tables created after this point. You will need to use something like Langley's suggestions to "upgrade" (or "promote," if you prefer) your table levels.

Hope this helps...

-- Lance

 

[Eviltwin]

Lance--
Thanks for the tip. I will reset the default. Here is another question. I was working on a new form using multiple tables. I wrote all the code and tried to run it but it just would not work. Just to see if the form was being strange --or I was losing my mind. I built a button that contained: action(datainsertrecord)-- even that would'nt work. It's like the form gets corrupted and just won't do anything. I then remembered that I had this happen once before. I rebuilt the form from scratch then pasted in all the code from the old form and everything works fine. Any idea what causes this?(besides an error on my part--which I have not ruled out
thanks

 

[footpad]

Eviltwin,

Technically, it's like this: forms sometimes get farkled. Yes, that is a technical term.

Seriously, I've seen stuff like happen only occasionally and then only when I was switching between versions. For example, I would see this from time to time when I'd switch from developing in Paradox 7.32 to Paradox 5.0 and back again--without saving the forms first.

Whenever you switch versions, you should always resave all forms, reports, libraries, and scripts.

Other than that, no. No idea.

Hope this helps...

-- Lance

 

[Eviltwin]

Lance-
Farkled!? That cracks me up.
ET