RE: [Programmer-VB] tanya recordcount

[ToebanNgrahRai78]

Maksud dari CursorLocation itu apaan seh? Untuk melakukan recordcount itu kok harus melakukan RsSP.CursorLocation=AdUseClient   -----Original Message----- From: Programmer-VB@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of LiveDeviL Sent: Saturday, October 15, 2005 2:24 PM To: Programmer-VB@yahoogroups.com Subject: Re: [Programmer-VB] tanya recordcount   halo... coba ditambah 1 baris code yang dicetak tebal... RsSP.CursorLocation=AdUseClient  If RsSP.State = adStateOpen Then RsSP.Close  RsSP.Open "SELECT * FROM SPECIAL_PRICE", koneksi, adOpenStatic, adLockOptimistic msgbox RsSp.recordcount regards, LiveDeviL On 10/15/05, Heintje <[EMAIL PROTECTED]> wrote: Coba jawab ah.... biasa nya seah saya pake perintah count untuk hitung jumlah record ...   Dim RsSP As ADODB.Recordset, vJmlRec As Doubler   RsSP.Open "SELECT count(NmField) as vJmlRec FROM SPECIAL_PRICE", koneksi, adOpenStatic, adLockOptimistic msgbox RsSp!vJmlRec   Ada yang laen ... ???   On 10/15/05, Aksan Kurdin < [EMAIL PROTECTED]> wrote: (jika ada yang berkesempatan membuat faq milis ini, maka pertanyaan ini juga masuk dalam faq tsb) lokasi cursor anda adalah di server, jadi recordset tidak bisa di bookmark dan recordcount akan selalu berisi -1 jadikan lokasi cursor anda di client: rssp.cursorlocation=aduseclient sebelum membuka recordset. aksan kurdin Pada tanggal 10/14/05, August sudana <[EMAIL PROTECTED]> menulis: > > hi.. > saya pnya masalah sbb: > script saya: > >  If RsSP.State = adStateOpen Then RsSP.Close >  RsSP.Open "SELECT * FROM SPECIAL_PRICE", koneksi, adOpenStatic, > adLockOptimistic > msgbox RsSp.recordcount > > hasil msgbox adalah -1 sedangkan table special_price saya masih kosong. > apa yang dibaca oleh msgbox RsSp.recordcount ? > kemudian, saya masih sedikit bingung kapan harus menggunakan: > - adOpenStatic > - adLockOptimistic > - adLockReadOnly > - adLockPessimistic > mohon pencerahan.. > terima kasih.. > > "damai itu indah.." > >  ________________________________ >  Yahoo! Music Unlimited - Access over 1 million songs. Try it free. > >  Untuk keluar dari millis ini, kirim email kosong ke: >  [EMAIL PROTECTED] > > > > > >  ________________________________ >  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. > >  ________________________________ > ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM --------------------------------------------------------------------~-> Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] 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/ Untuk keluar dari millis ini, kirim email kosong ke: [EMAIL PROTECTED] 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.