Article View: borland.public.cppbuilder.database.multi-tier
Article #1081Re: Getting data out of a table
From: Jerry Bloomfield (TeamB)
Date: Thu, 08 Jun 2000 00:00
Date: Thu, 08 Jun 2000 00:00
21 lines
1400 bytes
1400 bytes
On Thu, 8 Jun 2000 22:58:08 +0200, "Sphynx" <sphynx@x-quisite.eu.org> wrote: >Maybe a stupid question, but I'm pretty new to this. >I have an Access 97 database with a table. >How do I get a specific record from that table? > >I know how I can get the first record and so on, but a specific record...??? >In SQL I would do something like this. > ELECT * FROM Table WHERE Name = 'Jeroen'; Why not just put that SQL text into a TQuery and use it to get your data? I use TQuery components on MS-Access tables all of the time. In fact I almost never use TTable components personally... Jerry Bloomfield (TeamB) -- http://www.teamb.com JersWork@wwa.com Please do *NOT* send private e-mail without prior permission (my anti-spam filters will probably just delete it anyway <g>)
Technical Details
Message-ID:
<j6g0kso89icohdk85kd4e54mjptn4kahul@4ax.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<3940075c@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,fdbeb98bf1e9416a X-Google-Attributes: gidfcd2b,public From: "Jerry Bloomfield (TeamB)" <JersWork@wwa.com> Subject: Re: Getting data out of a table Date: 2000/06/08 Message-ID: <j6g0kso89icohdk85kd4e54mjptn4kahul@4ax.com> X-Deja-AN: 632847667 Content-Transfer-Encoding: 7bit References: <3940075c@dnews> Organization: LSVFA - Latest Software Version Freaks Anonomous Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier