Solved

problem with EmptyTable function

Posted on 1998-11-22
11
686 Views
Last Modified: 2008-02-01
Hi

I have a function that uses the EmptyTable function to clear the contents of a paradox table. This is my problem, if i run my program in the PC that i use for development (ie with Delphi), it works just fine. However, if i install BDE and my program in another computer (without Delphi), i sometimes get an Acess Violation error or an unrecoverable exception when the EmptyTable function is executed. Can't find out why....

has anyone faced such a problem??

Regards
Keith
0
Comment
Question by:keithcsl
  • 3
  • 2
  • 2
  • +4
11 Comments
 
LVL 5

Expert Comment

by:ronit051397
ID: 1347559
Are you sure you installed all the BDE necessary files?
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1347560
Delete your other question, you have post it twice.
0
 
LVL 8

Expert Comment

by:ZifNab
ID: 1347561
you are sure that you don't have some tables linked to each other and that you empty them in the correct order?
You are sure you are deploying the same BDE version as you use on your pc?
0
Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

 
LVL 1

Expert Comment

by:Oli2
ID: 1347562
you should compare the BDE-Settings on your Develop-Computer and the Standard BDE-Settings after the installation on the other Computers. Use bdecfg32.exe to do this. Take a look onto the page "System" and compare the settings. i.E. "MaxFileHandles" often causes trouble. Hope, it'll help.
Oliver
0
 
LVL 1

Author Comment

by:keithcsl
ID: 1347563
i have checked everything and still facing the same problem. i have resorted to not using the EmptyTable, but wrote a function to delete the records one at a time.

thank you all for your help...

Keith


0
 
LVL 1

Expert Comment

by:venks
ID: 1347564
Dear keithcsl
Try keeping the table's exclusive property to true just before
calling emptytable and then set exclusive to false after the call to emptytable
venks
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1347565
Yeah, Venks is right. This is a must if you want to use EmptyTable. Another option you have here is that you can also use "TTable.CreateTable" instead with the same effect. Here I think the condition is to close the table before calling it.
Anyhow, deleting all records one by one is a BAD solution. If you do this, you can notice that the record numbers remain. For example if you had 20 records before you deleted them, the next record you will append will have the number 21. If you have big tables, than it's even more destructive as you can imagine...
--Matvey
0
 

Expert Comment

by:mjustin
ID: 1347566
With a TQuery component you could also issue a 'delete from Tablename' command.
0
 
LVL 1

Author Comment

by:keithcsl
ID: 1347567
mjustin...

opps... i am sorry i have already implemented Matvey's suggestion to use CreateTable.... i should have asked Matvey to send his answer... (i forgot all about this question...)

matvey, could u please post an answer...

Keith
0
 
LVL 3

Accepted Solution

by:
Matvey earned 50 total points
ID: 1347568
Heyo Keith... Glad to help you again.
My best wishes for the new year!
--Matvey
0
 
LVL 1

Author Comment

by:keithcsl
ID: 1347569
happy new year to u too Matvey!!!
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Correct Component for Shopping Cart. 2 112
Base1 Encode/Decode 3 82
CheckListBox usage 3 71
Tvertscrollbox like a whatsapp layout delete messages 1 24
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question