We have already reported this problem to HP. I don't remember the SR number
off hand, but you should call it in too. Maybe if more people complain it
will get fixed quicker.
Reqards,
Ernest Hill
eXegeSys Inc.
144 S. 500 East.
Salt Lake City, UT 84102
[log in to unmask]
(801) 799-0917


-----Original Message-----
From: [mailto:[log in to unmask]]
Sent: Monday, February 22, 1999 2:35 AM
To: [log in to unmask]
Subject: SQL Statement Limited to 100 records


Dear all,

I am using VB 4.0 with MB Foster ODBCLink/SE to access my database resided
on HP3000. I know that the table that I accessed have 108 records. I used
the statements

    set SomeRS = SomeDB.Openrecordset(SomeSQLStatement, sqlpassthrough)
    while not SomeRs.eof
        Do Something
        SomeRS.MoveNext
    wend

Everytime it run into 101st records and start SomeRS.MoveNext it give me
error "Run-Time Error 3141". I don't know what is going wrong. Please help!

Brenda
***************************
Brenda is Brenda
e-mail: [log in to unmask]
***************************