[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 175
  • Last Modified:

Paradox Table in a directory under Windows NT

Hi

Under Windows NT, I have created a paradox table in a directory, and created several indexes as well.

What i have found is that whenever indexes are created, NT lockes the folder and does not allow you to Rename or Delete the folder.

How do i overcome this? I want the databases and index files to stay in the folder and be able to rename the folder. does this problem have anything to do with Opportunist Locking (which i am not familiar with) under NT?

Regards
Keith
0
keithcsl
Asked:
keithcsl
1 Solution
 
keithcslAuthor Commented:
Edited text of question
0
 
williams2Commented:
I'm not sure if you are right! What I think is, that you forgot to free the dbase-connection before leaving the application. The table should be closed when you exit, so that NT would know, that nobody is using the table.
Creating a primary index is only important to the table, but creating a secondary index (known as foreign keys) may depend upon other tables.

Opportunist Locking leaves a table-entry unlocked when reading but not when writing.

Pessimistic locking locks a tabel-entry BOTH when reading and writing.

pessimistic locking is mostly used with distributed services, where time becomes essential and where severel users may have interest in the same entry simultanously.

Locking is to prevent multiple users of a tableentry to write to the same datafield simultanously. This is of special importance to calculated fields.
0
 
kretzschmarCommented:
hi keithcsl,

this is the method from NT. The Folder is in use. Try to open a Winworddocument in a NT Folder, while you have open the document you cannot rename or delete this folder where the document resist.

meikl
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
RomanianCommented:
Look in BDE Administrator Configuration Page and set Property
System\Init\LOCAL SHARE = True
If that comment doesn't help you, send code which create this tables and indices.
0
 
keithcslAuthor Commented:
kretzschmar

i think you are right, NT keeps track of what files the application  is using. if an application references a file, for example, setting the TableName of a table will (i think) tell NT that the table is in use (even after the active property is set to false).

so, i have resorted to not having to rename the folder. initially i was using renaming of folders as a way of locking the directory, which i think is dumb. i am using file lockings now....

thank you all for bearing with my stupid question....

Regards
Keith
0
 
kretzschmarCommented:
hi keithcsl,

will you give me the points?

meikl
0
 
keithcslAuthor Commented:

sure, i think you have helped me verify that NT keeps track of an application's file usage more carefully than WIN95

ta

Keith
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now