cn dong pa..... emang rs bisa dikasih cursor location nya ?
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "Sistyo Alfan Tribowo"
<[EMAIL PROTECTED]>
Sent by: [email protected] 17/11/2005 10:34 AM
|
|
cn.CursorLocation = adUseClient ‘mungkin yang dimaksud rs kali yah.. bukan cn
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of JemyX Shinichi
Sent: 17 November 2005 10:23
To: [email protected]
Subject: Re: [Programmer-VB] Menghitung Record secara cepat
coba ganti
cn.CursorLocation = adUseClient
----- Original Message -----
From: "Others" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, November 17, 2005 10:13 AM
Subject: [Programmer-VB] Menghitung Record secara cepat
> Halo rekan2,
>
> Mohon pencerahannya...
> Bagaimana saya bisa menghitung jumlah record secara cepat?
> saya menggunakan ADO, dan cara saya adalah:
> cn.Open DSN, UID, PWD
> cn.CursorLocation = adUseServer
> rs.Open sql, cn, adOpenDynamic, adLockReadOnly
>
> Waktu saya cek dengan rs.RecordCount, isinya -1.
> Jumlah recordnya bisa ratusan ribu, mendekati jutaan.
>
> Apakah ada saran dari rekan-rekan agar saya bisa menampilkan
> record yang buayak ini dengan cepat? sekalian menampilkan
> progress barnya, makanya saya membutuhkan jumlah recordnya.
>
> Terima Kasih.
>
>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
> Yahoo! Groups Links
>
>
>
>
>
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB"
on the web.
- To unsubscribe from this group,
send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
