Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help!! Lost Index! 2
- Thread starter kruser
- Start date
- Thread starter
- #3
It wouldn't let me update the key, so that's the reason I couldn't restructure. I finally got it to work. I think maybe it wouldn't let me update because I had the table open & maybe it has to be closed. Jeez! This product is not very intuitive, to say the least!
What is tutility?
What is tutility?
Hi Kruser !
Paradox and some other databases run in the file system, rather than within a single huge file, like Oracle, fr'instance. If you have a table fred.db and you key it (always on the first 1 or more fields), then you'll see that you get a fred.px ("Primary indeX"
file too. If someone deletes or renames or moves fred.px then Paradox won't know anything about your index any more.
BTW, Paradox 5 was written for Windows 3.0. I'd seriously suggest that you get a copy of version 10 or 11 (coming very soon).
As per the suggestion, I'll make a FAQ of this - look at mirwin.homestead.com for Paradox FAQs.
Paradox and some other databases run in the file system, rather than within a single huge file, like Oracle, fr'instance. If you have a table fred.db and you key it (always on the first 1 or more fields), then you'll see that you get a fred.px ("Primary indeX"
file too. If someone deletes or renames or moves fred.px then Paradox won't know anything about your index any more. BTW, Paradox 5 was written for Windows 3.0. I'd seriously suggest that you get a copy of version 10 or 11 (coming very soon).
As per the suggestion, I'll make a FAQ of this - look at mirwin.homestead.com for Paradox FAQs.
-
2
- #6
kruser,
Adding to the previous comments:
1. You are correct, you have to close all windows and documents that refer to the table you're trying to restruture. I know it seems counter-intuitive, however, Paradox detects indexes when you open tables. If you restructure the table, the indexes may change and the view that's currently open may no longer be appropriate. (For example, you might delete the active index). Thus, to ensure that your data is always viewed properly, Paradox requires exclusive access to the tables being restructured.
Now, having said that, there is one condition where you can restucture an open table. If the table is only open in a single Table window, you can choose View | Restructure (I believe) to restructure. However, that's not terribly useful for you really shouldn't be using Table windows to work directly with your data except for purely (and brief) administrative tasks.
2) Just to clarify one minor point that Mike made: Paradox 5.0 was written for Windows 3.1, not Windows 3.0. It's a subtle (and, at this point, moot) distinction, but I do not believe the program will actually work under Windows 3.0.
He is correct in that you really should upgrade to a more current version. Version 11 is now available through WPO 2003 Professional. While it hasn't really changed since version 10 (save for bug fixes), it has changed rather dramatically since Paradox 5.0. There are numerous bug fixes, new features, and other stuff that will make your Paradox work much easier.
3) In addition to the web site Mike referred to, you may also find these helpful as well:
-- --
4) Paradox can be rather confusing to get the hang of, however, if you stick with it, it will make sense. While there are certain decision decisions that we could argue about, nearly all design decisions make sense when fully understood. I remember my learning curve and it didn't make sense for a very time. However, once I got the hang of it, it really made sense. Your mileage may vary, of course, but that's why you have such helpful folks slouching about areas like this and creating websites like the above.
Hope this helps...
-- Lance
Adding to the previous comments:
1. You are correct, you have to close all windows and documents that refer to the table you're trying to restruture. I know it seems counter-intuitive, however, Paradox detects indexes when you open tables. If you restructure the table, the indexes may change and the view that's currently open may no longer be appropriate. (For example, you might delete the active index). Thus, to ensure that your data is always viewed properly, Paradox requires exclusive access to the tables being restructured.
Now, having said that, there is one condition where you can restucture an open table. If the table is only open in a single Table window, you can choose View | Restructure (I believe) to restructure. However, that's not terribly useful for you really shouldn't be using Table windows to work directly with your data except for purely (and brief) administrative tasks.
2) Just to clarify one minor point that Mike made: Paradox 5.0 was written for Windows 3.1, not Windows 3.0. It's a subtle (and, at this point, moot) distinction, but I do not believe the program will actually work under Windows 3.0.
He is correct in that you really should upgrade to a more current version. Version 11 is now available through WPO 2003 Professional. While it hasn't really changed since version 10 (save for bug fixes), it has changed rather dramatically since Paradox 5.0. There are numerous bug fixes, new features, and other stuff that will make your Paradox work much easier.
3) In addition to the web site Mike referred to, you may also find these helpful as well:
-- --
4) Paradox can be rather confusing to get the hang of, however, if you stick with it, it will make sense. While there are certain decision decisions that we could argue about, nearly all design decisions make sense when fully understood. I remember my learning curve and it didn't make sense for a very time. However, once I got the hang of it, it really made sense. Your mileage may vary, of course, but that's why you have such helpful folks slouching about areas like this and creating websites like the above.
Hope this helps...
-- Lance
- Thread starter
- #7
I want to thank all who've responded here. I really appreciate you taking the time & effort to help. Unfortunately, it doesn't seem likely that my company will be spending the funds required to upgrade Paradox since we have only the 1 application on it. Thanks again!
kruser,
Well, that's OK. If you get stuck, feel free to post questions.
Also, if you have JavaSCript enabled, you can flag posts as helpful by clicking on the links with the stars next to them.
There's really no major reward for doing this, other than the ego boost to the person who posted the helpful message. (Everyone likes to know they've helped out now and again.)
In any event, welcome to the forum.
Hope this helps...
-- Lance
Well, that's OK. If you get stuck, feel free to post questions.
Also, if you have JavaSCript enabled, you can flag posts as helpful by clicking on the links with the stars next to them.
There's really no major reward for doing this, other than the ego boost to the person who posted the helpful message. (Everyone likes to know they've helped out now and again.)
In any event, welcome to the forum.
Hope this helps...
-- Lance
- Status
Similar threads
- Locked
- Helpful tip