Results 1 to 5 of 5

Thread: bizarre results

  1. Apr 8th, 2007, 09:04 AM #1
    simmi
    simmi is offline

    Thread Starter
    New Member
    Join Date
    Mar 2007
    Posts
    11

    bizarre results

    i m using an adodb recordset to display values from an access table but it is giving inconsistent results.instead of going into eof processing if no match is foound it sometimes exits out of vb.(at the same data everytime)i was totally confused so i opened the data file and it does not go to eof.it exits out of access.i fust dont know the problem.is it a virus.is a corrupt datafile creating this problem.pl help.the datafile has 300 records.
    thanks in advance.
    Reply With Quote Reply With Quote
  2. Apr 8th, 2007, 09:23 AM #2
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: bizarre results

    Would you please show us how you retrieve your data?
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  3. Apr 8th, 2007, 03:14 PM #3
    RS_Arm
    RS_Arm is offline
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 2007
    Location
    Planet Earth
    Posts
    282

    Re: bizarre results

    Try use the .movefirst method every time you want to verify if it is eof.
    Reply With Quote Reply With Quote
  4. Apr 8th, 2007, 03:18 PM #4
    RhinoBull
    RhinoBull is offline
    PowerPoster RhinoBull's Avatar
    Join Date
    Mar 2004
    Location
    New Amsterdam
    Posts
    24,132

    Re: bizarre results

    I'm afraid that wouldn't be enough - we need to see what you do in details.
    That is if you want some answers...
    Microsoft MVP - Visual Basic 2006-2013

    Why VB clears the clipboard on startup and how to avoid it? . Filtering Arrays . Save File To Database . Extract File From Database .
    Extract picture from database without using hard drive . Change Menu BackColor . How to use MS Flexgrid . Make Frame Transparent .
    The Easiest Way to Create an NT Service With VB6 . How to comment blocks of code in VB5 and VB6 . How to find and replace missing members of control array
    Visual Basic 6.0 On-Line Documentation . Connection Strings
    Reply With Quote Reply With Quote
  6. Apr 8th, 2007, 03:27 PM #5
    RS_Arm
    RS_Arm is offline
    Hyperactive Member RS_Arm's Avatar
    Join Date
    Mar 2007
    Location
    Planet Earth
    Posts
    282

    Re: bizarre results

    You should try, I got sometimes the same situation with ADODB.Recordset (it's basically the same object) and, since I've started to do that, i've never got "bizarre results". I hope it could result with you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width