Re: beginners help in programming ADO objects

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

Article #4360

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

#4360

From: Big Stew
Date: Mon, 14 Jan 2002 16:18

32 lines
1995 bytes

> 1) Right now I'm using this notation to read from or write to
> database-fields Form->Table->FieldValues["FieldToAccess"], but in the help
it states that this is slow because it returns a variant. How should I do to
speed it up and return the value as a) an Integer or b) an AnsiString

You could use TField::AsString, and TField::AsInteger, e.g.

  AnsiString Name ;
  int Code ;

  Name = ADOTable1->FieldByName("name")->AsString ;
  Code = ADOTable1->FieldByName("code")->AsInteger ;


> 2) I've managed to go through tables row by row, using Table->First() and
Table->Next, is it possible to do the same on the results from a query?

Yes, and it is an efficient way of achieving your goal, e.g.

ADOQuery1->Close() ;
ADOQuery1->SQL->Clear() ;
ADOQuery1->SQL->Add("select code, name from EmployeeTable") ;
ADOQuery1->SQL->Add("where code < 1000") ;
ADOQuery1->Open() ;

while(!ADOQuery1->Eof)
  {
   // Do some processing on each record
  ADOQuery1->Next() ;
  }

Big Stew

Technical Details

Message-ID: <3c4305af_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!sfo2-feed1.news.digex.net!intermedia!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3c42eba4$1_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,5a4ffac50c25512d
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-01-14 08:31:25 PST
From: "Big Stew" <Big_Stew@talk21.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c42eba4$1_2@dnews>
Subject: Re: beginners help in programming ADO objects
Date: Mon, 14 Jan 2002 16:18:08 -0000
Lines: 34
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: 212.19.90.97
Message-ID: <3c4305af_2@dnews>
X-Trace: dnews 1011025327 212.19.90.97 (14 Jan 2002 08:22:07 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!sfo2-feed1.news.digex.net!intermedia!news-out.spamkiller.net!propagator-la!news-in-la.newsfeeds.com!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message