baiknya sih
1. bikin sub untuk buka dan tutup connection database
variabel connection di dekalrasikan public agar semua object bisa
akses.
2. sebaiknya recordset yang dibuka di sub di tutup sebelum keluar sub.
dengan demikian variabel recordset di dekalrasikan hanya di sub itu
sendiri.
SUB buka1()
dim rsdtsurat as New ADODB.Recordset
rsdtsurat.open .......
.........
.......
rsdtSurat,close
set rsdtsurat = nothing
end sub
best regard
Den Aly
Nast Stsn
<[EMAIL PROTECTED] 宛先:
[email protected]
> cc:
送信者: 件名: [Programmer-VB] Bagaimana
cara membuka Tabel yang baik? Gimana nih??????
[EMAIL PROTECTED]
ogroups.com
02/27/2006 05:05
PM
Programmer-VB へ返
信してください
Nast Stsn <[EMAIL PROTECTED]> wrote:
Misal saya punya listing seperti ini,
ini hanya contoh, diasumsikan beda sub, gitu.
-------------------------------------------------------------------------------------------
Pada Sub 1
Set DtSurat = New ADODB.Connection
DtSurat.Provider = "microsoft.jet.oledb.4.0"
DtSurat.CursorLocation = adUseClient
DtSurat.Open App.Path & "\surat.mdb"
Set rsDtSurat = New ADODB.Recordset
rsDtSurat.Open "select * from tblsurat", DtSurat, adOpenDynamic,
adLockOptimistic
-------------------------------------------------------------------------------------------
Pada Sub 2
Set rsDtSurat = N! ew ADODB.Recordset
rsDtSurat.Open "select * from tblsurat where tglsurat =#" & DTPicker2.Value
& "#", DtSurat, adOpenDynamic, adLockOptimistic
--------------------------------------------------------------------------------------------
Pada Sub 3
Set rsDtSurat2 = New ADODB.Recordset
rsDtSurat2.Open "select * from tblsurat", DtSurat, adOpenDynamic,
adLockOptimistic
-------------------------------------------------------------------------------------------
Berati disini saya telah membuka tabel sebanyak tiga kali bahkan dalam
prakteknya bisa lebih.
1. Jika kondisi tersebut bisa dilakukan dengan perpindahan record
(menggunakan metode MoveFirst, MoveLast, dsb)
apa yang harus saya pilih antara metode open dengan metode Moving
apabila dihubungkan dengan
kecepatan proses jalannya program?
2. Dan Saya minta tolong jelaskan bagaimana cara yang terbaik dalam membu!
ka tabel-tabel dalam Database!
Terima kasih sebelumnya.
Brings words and photos together (easily) with
PhotoMail - it's free and works with Yahoo! Mail.
Yahoo! Mail
Use Photomail to share photos without annoying attachments.
Yahoo! Mail
Bring photos to life! New PhotoMail makes sharing a breeze.
Wahana Programmer Groups Links
SPONSORED LINKS
Programmer Indonesia Basic programming
language
Computer programming Programming Java programming
languages languages 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.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
