Thread View: borland.public.cppbuilder.database.ado
5 messages
5 total messages
Started by crhras
Sat, 22 Jul 2006 02:09
Basic fetch record question
Author: crhras
Date: Sat, 22 Jul 2006 02:09
Date: Sat, 22 Jul 2006 02:09
22 lines
1658 bytes
1658 bytes
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
Re: Basic fetch record question
Author: crhras
Date: Mon, 24 Jul 2006 18:54
Date: Mon, 24 Jul 2006 18:54
37 lines
2377 bytes
2377 bytes
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 > > >
Re: Basic fetch record question
Author: Viatcheslav V. Vassiliev
Date: Tue, 25 Jul 2006 19:25
Date: Tue, 25 Jul 2006 19:25
54 lines
3152 bytes
3152 bytes
Why do not you use ADO with CursorLocation = clClient without ClientDataSet? TDBLookupCombobox may be what you need. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "crhras" <crhras@sbcglobal.net> �������/�������� � �������� ���������: news:44c5176d$1@newsgroups.borland.com... > > 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 >> >> >> > >
Re: Basic fetch record question
Author: crhras
Date: Tue, 25 Jul 2006 22:13
Date: Tue, 25 Jul 2006 22:13
68 lines
3585 bytes
3585 bytes
There might be 100,000 records in this database and I don't think a LookupComboBox would be good for that, would it ? Also, I'm not even sure of how to implement the solution you are talking about so I think I need to do some extensive reading on the subject. Thanks for your response ! "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message news:44c6702d$1@newsgroups.borland.com... > Why do not you use ADO with CursorLocation = clClient without > ClientDataSet? TDBLookupCombobox may be what you need. > > //------------------------------------------ > Regards, > Vassiliev V. V. > http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + > ADO.Net > http://www.oledbdirect.com - The fastest way to access MS SQL Server, > MS Jet (Access) and Interbase (through OLEDB) > > > "crhras" <crhras@sbcglobal.net> �������/�������� � �������� ���������: > news:44c5176d$1@newsgroups.borland.com... >> >> 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 >>> >>> >>> >> >> > >
Re: Basic fetch record question
Author: Viatcheslav V. Vassiliev
Date: Wed, 26 Jul 2006 06:17
Date: Wed, 26 Jul 2006 06:17
85 lines
4486 bytes
4486 bytes
Does not ClientDataSet fetchs all rows into memory cache? For 100,000 records it would be better to restrict number of returned records with WHERE. //------------------------------------------ Regards, Vassiliev V. V. http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + ADO.Net http://www.oledbdirect.com - The fastest way to access MS SQL Server, MS Jet (Access) and Interbase (through OLEDB) "crhras" <crhras@sbcglobal.net> �������/�������� � �������� ���������: news:44c6979e$1@newsgroups.borland.com... > > There might be 100,000 records in this database and I don't think a > LookupComboBox would be good for that, would it ? Also, I'm not even sure > of how to implement the solution you are talking about so I think I need > to do some extensive reading on the subject. > > Thanks for your response ! > > > > "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message > news:44c6702d$1@newsgroups.borland.com... >> Why do not you use ADO with CursorLocation = clClient without >> ClientDataSet? TDBLookupCombobox may be what you need. >> >> //------------------------------------------ >> Regards, >> Vassiliev V. V. >> http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + >> ADO.Net >> http://www.oledbdirect.com - The fastest way to access MS SQL Server, >> MS Jet (Access) and Interbase (through OLEDB) >> >> >> "crhras" <crhras@sbcglobal.net> �������/�������� � �������� ���������: >> news:44c5176d$1@newsgroups.borland.com... >>> >>> 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 >>>> >>>> >>>> >>> >>> >> >> > >
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads