Reading one record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bilal Esmael - 20 Mar 2008 10:47 GMT

Hi

I'm building an application that will read very big tables, so I want to
read the records one bye one.
I DON'T want reading all data and loading it to DataTable and reading from
DataTable, I want to read the records directly from database

Thanks

Reply to this Message

Mohammad Al-Ma'any - 24 Mar 2008 22:07 GMT

You can simply modify your "select" statement

i.e
rs.open "Select Name, Age, Address from Table1"
while not rs.EOF
msgbox rs(1)
rs.movenext
wend
rs.close

hope that helps ya

> Hi
>
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

Sylvain - 24 Mar 2008 23:40 GMT

Mohammad Al-Ma'any wrote on 24/03/2008 22:07:

>> I'm building an application that will read very big tables, so I

what is "big" ? more than 100.000 records ?

for small table (about 10k records) getting all records in one request
is still the best solution.

>> want to read the records one bye one. I DON'T want reading all data
>> and loading it to DataTable and reading from DataTable, I want to

did you mean to transfer all response at once ?

>> read the records directly from database

did you mean you want to lock the base and perform indicidual requests?

I hope it's a single-user, local, base !

> You can simply modify your "select" statement
>
> i.e rs.open "Select Name, Age, Address from Table1" while not rs.EOF
> msgbox rs(1) rs.movenext wend rs.close

what kind of language is it ?

Sylvain.

Reply to this Message

Reading one record

Free Magazines