469,088 Members | 1,236 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,088 developers. It's quick & easy.

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 2730
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.