[Gambas-user] database eof and bof

[nigel at ...38...]

Neil,

I've changed you program as follows, but see no problems:

Nigel


> Message date : Mar 07 2005, 05:36 PM
> From : "Neil Fallon" <nfallo at ...734...>
> To : gambas-user at lists.sourceforge.net
> Copy to : 
> Subject : Re: Re: [Gambas-user] database eof and bof
> 
> Hi Nigel,
> 
> The complete project was posted to Gambas Forge.  It is called quiz.  If
> you remove the check for the record number that I have included in the
> move next you will see the message that is displayed to the user.
> 
> Neil
> 
> On Mon, 2005-03-07 at 17:37 +0100, nigel at ...38...
> wrote:
> > Neil,
> > 
> > Please publish your code so that we can look into the problem you
> > mention with 'Available'.  My usage of:
> > 
> > hResult = $hConn.Exec("select * from table")
> > hResult.MoveLast()
> > 
> > hResult.moveNext()
> > 
> > IF hResult.Available THEN
> > 
> >     PRINT "Record Available"
> > 
> > ELSE
> > 
> >     PRINT "Not available"
> > 
> > ENDIF
> > 
> > ....gives me "Not Available"
> > 
> > Regards
> > 
> > Nigel
> > 
> >         > Message date : Mar 06 2005, 02:11 PM
> >         > From : "Neil Fallon" 
> >         > To : gambas-user at lists.sourceforge.net
> >         > Copy to : 
> >         > Subject : Re: [Gambas-user] database eof and bof
> >         > On Sun, 2005-03-06 at 01:45 -0500, Rob wrote:
> >         > > On Sunday 06 March 2005 01:31, Neil Fallon wrote:
> >         > > > I am at the whims of the users moving forward and
> >         backward. The
> >         > > > easier way for me may be to just check the first and
> >         last records
> >         > > > in the database. My key field is an auto increment
> >         number. I can
> >         > > > just check if the value is 1 for the first record or
> >         what ever the
> >         > > > number is for the last record value in the database.
> >         > > 
> >         > > I guess that's cool as long as you're sure there'll never
> >         be holes in 
> >         > > the database, but I personally would check r.Available
> >         regardless to 
> >         > > avoid the possibility of a runtime error.
> >         > > 
> >         > > Rob
> >         > > 
> >         > Hi Rob,
> >         > 
> >         > When I check Available on the last record I get an error
> >         stating there
> >         > are no more records. I don't want the message transmitted to
> >         the user.
> >         > 
> >         > Neil
> >         > 
> >         > 
> >         > 
> >         > 
> >         > -------------------------------------------------------
> >         > SF email is sponsored by - The IT Product Guide
> >         > Read honest & candid reviews on hundreds of IT Products from
> >         real users.
> >         > Discover which products truly live up to the hype. Start
> >         reading now.
> >         > http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> >         > _______________________________________________
> >         > Gambas-user mailing list
> >         > Gambas-user at lists.sourceforge.net
> >         > https://lists.sourceforge.net/lists/listinfo/gambas-user
> >         > 
> >         > 
> > 
> > 
> > 
> > ______________________________________________________________________
> > Whatever you Wanadoo
> > 
> > This email has been checked for most known viruses - find out more
> > here
> 
> 
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
> 
> 

-- 

Whatever you Wanadoo:
http://www.wanadoo.co.uk/time/

This email has been checked for most known viruses - find out more at: http://www.wanadoo.co.uk/help/id/7098.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: frmMain.class
Type: application/octet-stream
Size: 16823 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20050309/0252b90d/attachment.obj>