Re: CDatabase CRecordset - How to get the number of rows?

david,

glad to be of assistance....

rlf


"David++" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:483AFE5A-6416-40EB-ABEA-C4F84B22F877@xxxxxxxxxxxxxxxx
> Hi Roy :-)
>
> It works now! Thankyou very, very much for your help! If I could I woyuld
> buy you a beer,
>
> All the best,
> David
>
> "Roy Fine" wrote:
>
> >
> > "David++" <David@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:63FB861B-E7A4-408C-A964-A4DD36A98B16@xxxxxxxxxxxxxxxx
> > > Hi Roy,
> > >
> > > This is the code I have so far -
> > >
> > > CRecordset rs(&db);
> > >
> > > rs.Open(CRecordset::forwardOnly,"SELECT * FROM
> > Records",CRecordset::readOnly);
> > >
> >
> > NO! -- the SQL command should be "Select Count(*) FROM Recrds"
> >
> > regards
> > Roy
> >
> >
> >
> >


.

Relevant Pages

  • Re: Song
    ... > David wrote: ... >> Roy Schestowitz do you really want to be associated with the Nazis? ... Your problem Dave is that seem to think there is only one ...
    (alt.internet.search-engines)
  • Re: Song
    ... >> David wrote: ... >>> Roy Schestowitz do you really want to be associated with the Nazis? ... Your problem Dave is that seem to think there is only one ...
    (alt.internet.search-engines)
  • Re: CDatabase CRecordset - How to get the number of rows?
    ... Best Regards, ... David ... "Roy Fine" wrote: ... > What is the value of dataStr in the CRecordset::Open call. ...
    (microsoft.public.vc.mfc)
  • Re: CDatabase CRecordset - How to get the number of rows?
    ... The database ... David ... "Roy Fine" wrote: ... > return anything but ONE row with one scalar type. ...
    (microsoft.public.vc.mfc)
  • Re: Iuron Registration (Formerly AdWords)
    ... >>David wrote: ... there is nothing that stands between Roy and his ability ... >>to afford a dedicated server and have some spare money to buy books needed ... > Absolutely a few dollars a day from Adsense is realistic for his site ...
    (alt.internet.search-engines)
Loading