🚀 go-pugleaf

ok, no answer to this question.  Well, how about a little feedback regarding 
it.  Have I posted in the wrong group.  Is the question too basic ?  I tried 
Googling to get an answer and couldn't find any sources where this exact 
problem is discussed.  I'm reading usage of datasets and providers and each 
day find some clue which helps me to solve the problem but I am afraid that 
the in-depth knowledge required will take me a month or so.



"crhras" <crhras@sbcglobal.net> wrote in message 
news:44c188e0$1@newsgroups.borland.com...
>I have a database of phone numbers and names like this:
>
> phone VARCHAR(10);
> name VARCHAR(20);
>
> I want to be able to enter a phone number and check the database for a 
> match and if found, display the name.  If a match is not found, then a 
> name can be entered and a new record will be added.
>
> The problem is I am using TDBEdit controls on the form which display the 
> current value of the data fields to which they are linked.  How can I 
> blank the DBEdit control out and allow it to accept the phone number which 
> I will be searching on.
>
> If phone number is the primary key then I can do it by calling SetKey() 
> then EditKey() on the ClientDataSet and ReadOnly = false on the phone 
> TDBEdit. But what if the phone number is not the primary key and I want to 
> use Locate() instead to find the matching phone number ?
>
> In advance,
> Thank you,
> Curt
>
>
>