HP3000-L Archives

February 1999, Week 4

HP3000-L@RAVEN.UTC.EDU
Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
SQL Statement Limited to 100 records
From:
²Â³J <[log in to unmask]>
Reply To:
²Â³J <[log in to unmask]>
Date:
Mon, 22 Feb 1999 17:34:58 +0800
Content-Type:
text/plain
Parts/Attachments:
text/plain (21 lines) 
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]
***************************

ATOM RSS1 RSS2