Getting data out of a table

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Sphynx Thu, 08 Jun 2000 00:00

#1080

Author: Sphynx
Date: Thu, 08 Jun 2000 00:00

20 lines
1017 bytes

Hello all,

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.

SELECT * FROM Table WHERE Name = 'Jeroen';

Thanks in advance.

Jeroen.
--
_______________________________________
Rules can not be broken! They can only be bent!
<<-- X-quisite Developers Team -->>

Re: Getting data out of a table

#1081

Author: Jerry Bloomfield (TeamB)
Date: Thu, 08 Jun 2000 00:00

21 lines
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>)

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