Solved

Problems with Emptytable.....

Posted on 1998-01-06
15
158 Views
Last Modified: 2010-04-04
I use Emptytable to delete all records in my table. The problem is that I get "Access violation" on some computers, and I don't have a clue why! Is it possible that it has something to do with networks. It works just fine on computers that are "Single", without internet connection or any other network connections.
(The table property "Exclusive" is set to true for the table..)
I use Delphi Developer 2.0

Thanx!
Erik N
 
0
Comment
Question by:Erik N
  • 7
  • 5
  • 2
  • +1
15 Comments
 
LVL 2

Expert Comment

by:Waldek
ID: 1355486
Have you Exclusive=true
0
 

Author Comment

by:Erik N
ID: 1355487
Edited text of question
0
 

Author Comment

by:Erik N
ID: 1355488
Edited text of question
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
LVL 3

Expert Comment

by:Matvey
ID: 1355489
Have you tried running it from Delphi or the EXE alone?
I don't remember which version of Delphi did it but it opened the table also and then you can't set the table to be exclusive...

Matvey
0
 

Author Comment

by:Erik N
ID: 1355490
I run the application alone (.EXE) on the computers that i failed on.

Erik N
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1355491
I use Emptytable on WinNT. I am connected to the Internet and the network and it's working fine.
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1355492
You need to close the table before doing Emptytable.
0
 

Author Comment

by:Erik N
ID: 1355493
Before I use EmptyTable I use the following line:
Dm6.Table1.Active:=False;
This should be the same as closing the table.
I must have done some stupid, because I cannot find anything that seems to be theproblemsource...
It looks like this:
Dm6.Table1.Active:=False;
Dm6.Table1.EmptyTable;
Dm6.Table1.Active:=True;

Erik N.

0
 
LVL 3

Expert Comment

by:Matvey
ID: 1355494
Does the error occures on the seccond line?
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1355495
Do you write something like this:

Table1.Close;
Table1.Exclusive:=True;
Table1.EmptyTable;
Table1.Exclusive:=False;
Table1.Open;

0
 

Author Comment

by:Erik N
ID: 1355496
I tried this too, and it didn't work...
I use the installationdisks I've made, and the function Emptytable only works on a computer that has Delphi installed, not on any other....

Erik N.
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1355497
Asuming, you are working with paradox, In the InstallShield, Did you entered the General options and marked the option BDE(Borland Database Engine)?
0
 

Author Comment

by:Erik N
ID: 1355498
Thank you ronit, for your suggestion. It turned out, I had only selected partial BDE installation, and probably there is necessary to select a "Query driver" aswell( wich I hadn't). However, I tried to select "Full BDE installation", and the problem was solved, just like that!

Thank you all!
To ronit: If you want the points for this, please propose an "Answer".

Erik N.
0
 
LVL 5

Accepted Solution

by:
ronit051397 earned 100 total points
ID: 1355499
OK.
0
 

Author Comment

by:Erik N
ID: 1355500
Thank you for your help, ronit. I guess I'd better R.T.F.M. (Read The Fuckin' Manual)

Erik N
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

785 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