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

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)