471,873 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,873 software developers and data experts.

Stream size limitation

Hi all,
I am new to the ADODB.Stream
I am using following code

lRecordset.Open "Select * from <some table-name>"
'this query return more than 1000 records
dim lstream as new ADODB.stream
'assigning the recordset data to the stream
lrecordset.save lstream
lStream.Position = 0
Dim lRecordset2 As New ADODB.Recordset
lRecordset2.Open lstream
MsgBox lRecordset2.RecordCount

my problem is that query is returning say 1500 records but when i am
again assigning the same stream to another recordset it is copying
only 485 records
that is lstream is saving only 485 records...is there any size limit
on stream...?
how i can do this using stream only....
If u have any solution plz reply back..
Thanks in advance...
Jul 20 '05 #1
1 2807
Hi all,
I solved the problem
We just need to put
lRecordset.CursorLocation = adUseClient
before putting the recordset into Stream
Anyway thanks to all

sd*******@yahoo.com (Sandeep) wrote in message news:<33*************************@posting.google.c om>...
Hi all,
I am new to the ADODB.Stream
I am using following code

lRecordset.Open "Select * from <some table-name>"
'this query return more than 1000 records
dim lstream as new ADODB.stream
'assigning the recordset data to the stream
lrecordset.save lstream
lStream.Position = 0
Dim lRecordset2 As New ADODB.Recordset
lRecordset2.Open lstream
MsgBox lRecordset2.RecordCount

my problem is that query is returning say 1500 records but when i am
again assigning the same stream to another recordset it is copying
only 485 records
that is lstream is saving only 485 records...is there any size limit
on stream...?
how i can do this using stream only....
If u have any solution plz reply back..
Thanks in advance...

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Anurag | last post: by
5 posts views Thread by praveen | last post: by
6 posts views Thread by AB | last post: by
9 posts views Thread by anachronic_individual | last post: by
4 posts views Thread by AviCoh | last post: by
4 posts views Thread by Craig Buchanan | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.