Solved

Search...

Posted on 1998-08-28
11
205 Views
Last Modified: 2010-04-04
This question is easy. I'm developing a batabase system to my university and it must be FAST and ELEGANT. I know that there are a lot of ways to perform a search, but I'd like to know the best in this case:

    I have a form with several DBEdits linked to one table. The first DBEdit is the primary key of the table. I need to search the table to avoid key violations and notify the user. It's easy, but if the key is in the second DBEdit and I perform the search and a key violation ocurrs, the text of first BDEdit is lost. How solve it? I'd like to know your opinions about the best searchs and the right way to use CachedUpdates.

                              Tanks in advance.
0
Comment
Question by:oberdan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 

Expert Comment

by:chrismo
ID: 1338001
So you're creating a form that will link to any table in the database? Or is it fixed to a single table?
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1338002
Best in my opinion, if possible, is SQL queries.
TTable has two ways of searching: TTable.Locate, and the Setkey-gotokey sequence.

CachedUpdates should be used if you want to be able to cancel changes made to the table at some point.

-Please be a bit more detailed with the key violation problem. I can't fully see what causes what...

--Matvey
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1338003
CachedUpdates are also used in C/S dbs. This shouldn't apply to here, right?
0
Independent Software Vendors: 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!

 
LVL 3

Expert Comment

by:Matvey
ID: 1338004
I think all search methods should be working at the same speed. It's the same BDE, so I don't see a reson for fundamental difference. Anyway, you can only see it in huge dbs. Is it the case here?
0
 
LVL 3

Expert Comment

by:Matvey
ID: 1338005
I see SQL isn't the best idea here. I's use TTable.Locate...
0
 

Author Comment

by:oberdan
ID: 1338006
To chrismo:

At first, a single table, but is possible that the form needs to be linked to any table.
0
 

Author Comment

by:oberdan
ID: 1338007
To Matvey:

The system will be C/S. The key violation problems are referent to duplicated keys.
0
 
LVL 4

Expert Comment

by:itamar
ID: 1338008
Hi all,

Key-violation in a search operation ? I thought key-violation was related to updating / inserting a record that causes a duplicate key entry or a null one ...

Am I wrong ?
0
 
LVL 2

Expert Comment

by:333
ID: 1338009
oberdan,
if you use Paradox or dBase tables, the fastest way to search will be TTable.Locate (your tables must be indexed). If you use SQL tables or your Pdox or dBase tables aren't indexed, use TQuery instead.
0
 

Author Comment

by:oberdan
ID: 1338010
To Itamar:

      You're not wrong. I don't explain the question. My problem is at insertion. When the user insert data to a primary key field, I want to search to verify if thew data typed are not already present on the table. I'd not like to lost the data typed by user on the fields when I change the table state to perform the search. I hope it can help.


       
0
 
LVL 3

Accepted Solution

by:
Matvey earned 100 total points
ID: 1338011
Here's something I wrote long time ago...

--Matvey
_____________________________________________________
procedure TForm1.Table1BeforePost(DataSet: TDataSet);
var t : TQuery;
begin
  t := TQuery.Create(self);
  t.DataBaseName := table1.DatabaseName;

  //change to your table name...
  t.SQL.Add('select * from animals where name = ''' +             table1.Fields[0].asstring + ''';');

  t.Open;
  if (t.RecordCount > 0) then
  Begin
    ShowMessage('Value exists!');
    Abort;
  end;
  t.close;
  t.free;
end;
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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

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…
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses
Course of the Month7 days, left to enroll

623 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