Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Finding Paradox records from witnin Delphi

Posted on 1998-06-12
2
Medium Priority
?
207 Views
Last Modified: 2010-04-03
I have a paradox 7 table with two keys, the primary key is a field called ID and the secondary key is a field called CWWORD.  I have a normally edit component on a form in which the user enters the word they want to search for.

What need to do is determine whether the record exists.

This is what I think is the correct method of doing this :)

Table.Active := True;
Table.IndexName := CWWORD;
if Table.FindKey(Edit.Text) then
  record found
else
  record not found;

This piece of code doesn't work but but I know it's something similiar.  Can you help ?

0
Comment
Question by:neld
[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
2 Comments
 

Accepted Solution

by:
jhun earned 60 total points
ID: 1352429
The findkey takes an array of const as a parameter. Try this:

with Table do
begin
  EditKey;
  FieldByName('CWWORD').AsString := Edit.Text;
  if GotoKey then
   rec found
  else rec not found

gr. John

end;
0
 

Expert Comment

by:bijoyn
ID: 1352430
since u know that the fieldname is ID what u can do is

if Table1.Locate('ID',Edit1.Text,[]) then
   Showmessage('Found')
else
   Showmessage('Not Found');

----------------------
The above code should help find the records u are looking for in a table. If the key has multiple columns then separate the column names by comma. and the same for the values which will be shown as [value1, value2...] etc.

Bijoy

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.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
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. …
Suggested Courses

610 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