Re: Problems with empty recordsets

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

Article #522

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

#522

From: George Nakos
Date: Thu, 01 Sep 2005 13:29

35 lines
2033 bytes

On Thu, 01 Sep 2005 16:03:44 +0300, Arnie <none> wrote:


> This probably indicates you need the ADO patch from Borland.  BCB
> 5 had two patches, one for the product in general and one for
> ADO.

Just did it!

>
>>
>> BTW I'm using BC++5 and MS Access as the database.
>>
>
>                      sprintf(send,"SELECT DISTINCT DriverNumber \
>  FROM tbl_Drivers Tbl_drivers \
> WHERE  DriverNumber = %d",pin);
>                      GenQuery->Close();
>                      GenQuery->Active=false;        // You don't
> need this.  Close() has already done this
>                      GenQuery->SQL->Clear();
>                      GenQuery->SQL->Text=send;
>                      GenQuery->Open();
>
>                     if ( GenQuery->Eof )
>                         // ID doesn't exist
>

Now it seems to be working. Thanks for the tips!

George

-- 
Using Opera's revolutionary e-mail client: http://www.opera.com/mail/

Technical Details

Message-ID: <op.swfeemrnqf2fxd@promitheas.metron.internal>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

References: <op.swfb42x5qf2fxd@promitheas.metron.internal> <4316fbe3$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,a3aa13efef982538
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Problems with empty recordsets
References: <op.swfb42x5qf2fxd@promitheas.metron.internal> <4316fbe3$1@newsgroups.borland.com>
Message-ID: <op.swfeemrnqf2fxd@promitheas.metron.internal>
From: "George Nakos" <gnakos@metronco.gr>
Organization: Metron LTD
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-7
MIME-Version: 1.0
Content-Transfer-Encoding: Quoted-Printable
Date: Thu, 01 Sep 2005 16:29:00 +0300
User-Agent: Opera M2/8.10 (Win32, build 7685)
NNTP-Posting-Host: 83.235.222.66
X-Trace: newsgroups.borland.com 1125581230 83.235.222.66 (1 Sep 2005 06:27:10 -0700)
Lines: 35
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!npeer.de.kpn-eurorings.net!border2.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Reply to Parent Message