Article View: borland.public.cppbuilder.database.ado
Article #3759Re: Accessing a database without a form
From: MarkR
Date: Wed, 19 Jun 2002 00:53
Date: Wed, 19 Jun 2002 00:53
53 lines
2131 bytes
2131 bytes
The following segment of code shows a full console application to do the
same as my previous example
sample1.cpp
//--------------------------------------------------------------------------
-
#include <vcl.h>
#include "stdio.h"
//#include <DBCtrls.hpp>
#include <Db.hpp>
#include <DBTables.hpp>
#pragma hdrstop
//--------------------------------------------------------------------------
-
#pragma argsused
int main(int argc, char* argv[])
{
AnsiString sMax;
int nMax;
TQuery *qryTemp = new TQuery(Application);
qryTemp->SQL->Add("select max(LeftCaliper) nMAX from
':SSCOMPS:calipers.db'");
qryTemp->Open();
sMax = qryTemp->FieldByName("nMAX")->AsString;
qryTemp->Close();
delete qryTemp;
ShowMessage(sMax);
return 0;
}
//--------------------------------------------------------------------------
-
"Ferran Barba" <reg@sifbm.com> wrote in message news:3d0fbf45_2@dnews...
> Hi,
>
> I'm new to BCB, coming from VB. I want to access (read, write, ...) an
> Access database WITHOUT using a form, like when using DAO/ADO objects in
VB.
> How can this be done?
>
> Thanks in advance.
>
> Ferran Barba
>
>
>
Technical Details
Message-ID:
<3d0fd5ae$1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!supernews.com!news.tele.dk!small.news.tele.dk!129.250.35.146!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnewsReferences:
<3d0fbf45_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,5438de8422c49d3 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-06-18 17:56:43 PST From: "MarkR" <mark.richards8@wapthespamntlworld.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3d0fbf45_2@dnews> Subject: Re: Accessing a database without a form Date: Wed, 19 Jun 2002 01:53:02 +0100 Lines: 55 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 213.107.139.203 Message-ID: <3d0fd5ae$1_1@dnews> X-Trace: dnews 1024447918 213.107.139.203 (18 Jun 2002 17:51:58 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!supernews.com!news.tele.dk!small.news.tele.dk!129.250.35.146!iad-peer.news.verio.net!news.verio.net!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews