Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Problems with Emptytable.....

Posted on 1998-01-06
15
Medium Priority
?
165 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 400 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

916 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