Re: SELECT MAX(...) returns 0

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Pascal Biston (pbi_at_sigroup.be)
Date: 05/10/04 

Date: Mon, 10 May 2004 16:58:34 +0200

Yes, I refer rs(0)

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> a écrit dans le
message de news:utLbyY1MEHA.892@TK2MSFTNGP09.phx.gbl...
> What's your code look like: how are you referring to the field when you
> retrieve it from the recordset?
>
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (No private e-mails, please)
>
>
> "Pascal Biston" <pbi@sigroup.be> wrote in message
> news:#5jUX90MEHA.340@TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > No where clause, just a "SELECT MAX(NumChant) From Chant"
> >
> > Regards,
> >
> > Pascal
> >
> > "Jan Hyde" <StellaDrinker@REMOVE.ME.uboot.com> a écrit dans le message
de
> > news:rq1k90lfpnbhjvj1hmf8qmad18ktvcao41@4ax.com...
> > > "Pascal Biston" <pbi@sigroup.be>'s wild thoughts were
> > > released on Thu, 6 May 2004 11:07:43 +0200 bearing the
> > > following fruit:
> > >
> > > >Hi,
> > > >
> > > >I've the following problem : with Windows 98, MDAC 2.8, a program
write
> > in
> > > >VB 6.0, used ADO recordset when I execute the following instance
SELECT
> > > >MAX(NumChant) from ... the results is 0 but my database is not empty
> (+-
> > > >2500 records). The fields NumChant is varchar !
> > > >
> > > >Any idea ?
> > > >
> > >
> > > Is there a where clause on the SQL?
> > >
> > >
> > >
> > > --
> > > Jan Hyde (MVP - Visual Basic)
> > >
> > > Ramadan is fast approaching. (Priscilla H Ballou)
> > >
> > > [Abolish the TV Licence - http://www.tvlicensing.biz/]
> > >
> >
> >
>
>

Relevant Pages

  • Re: What do they mean by "new"???
    ... I am referring to a different style or approach to music. ... am referring to neoclassicalism, minimalism, etc. ... which would certainly refer to 1950 or so and on (and perhaps earlier ... as I am not sure where the style break most identifiably occurs - ...
    (rec.music.classical.recordings)
  • Re: OT--REEFER vs. REFER
    ... you do have a "refer" in your travel trailer. ... To assign or attribute to; regard as originated by. ... To direct the attention of: refer him to his duties. ... questions referring to yesterday's lecture. ...
    (rec.outdoors.rv-travel)
  • Re: Wikipedia Censorship
    ... The Sikh reporter on The One Show asked if he was supposed to refer to a black cab as "a taxi of colour" - if it's black it has no colour and if it has colour it's not black. ... The other way of referring to him is African-American which leads to the intersting image of an Afro-Merkin:-> ... Do all these people who "refer" to Obama see someone in the street and shout, ...
    (uk.telecom.broadband)
  • Re: c without usin any graphics function
    ... seen "platform" used to refer to the system hardware and software ... But I've seen it used to refer ... Well, obviously he can't be referring to the hardware-only definition, ... "platform" that he's referring to. ...
    (comp.lang.c)
  • Re: "static" prefix - to parallel "this" prefix
    ... And how does the above tell you *which* other class you're referring to? ... I asked above "how will you refer to static methods/variables in *OTHER* ... the table and you will *still* have to type the classname to provide ... "By doubting we come to inquiry, through inquiry truth." ...
    (comp.lang.java.programmer)