ADO / BCB6 - How to use data retrieved from SQL server ? - Article 591 - go-pugleaf

Article View: borland.public.cppbuilder.database.ado

Article #591

Back to borland.public.cppbuilder.database.ado Previous Next

ADO / BCB6 - How to use data retrieved from SQL server ?

#591

From: theonlyscoop
Date: Mon, 19 Sep 2005 11:34

19 lines
1684 bytes

Hi!

I am trying to retrieve data from a SQL server, but so far I have not
managed to use the data.

Can someone give me an example of how to retrieve data from a SQL
database, eg. how do I execute the SQL statement ("select * from
database") and return to result in Edit1 (an editbox).

What I'm having trouble with here is proberly the proper use of
'RecordSet'

Please give me some kind of example how to do this

Best Regards
Martin Jeppesen


NOTE: I'm using Borland C++ Builder 6.0 Pro

Technical Details

Message-ID: <1127129667.498100.70160@f14g2000cwb.googlegroups.com>

Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,93e3643d70da3624,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail
From: "theonlyscoop" <theonlyscoop@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ADO / BCB6 - How to use data retrieved from SQL server ?
Date: 19 Sep 2005 04:34:27 -0700
Organization: http://groups.google.com
Lines: 20
Message-ID: <1127129667.498100.70160@f14g2000cwb.googlegroups.com>
NNTP-Posting-Host: 80.63.27.146
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1127129672 27909 127.0.0.1 (19 Sep 2005 11:34:32 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 19 Sep 2005 11:34:32 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 srv-vw-nsb:8081 (IWSS), 1.0 SRV-VW-NSB
Complaints-To: groups-abuse@google.com
Injection-Info: f14g2000cwb.googlegroups.com; posting-host=80.63.27.146;
   posting-account=NmNPmQ0AAABUaJUBdZ_rGlEDlpsOX0uX