Re: Fwd: [Programmer-VB] Delete recordset

Thu, 01 Jun 2006 01:47:02 -0700

gak bs jalanya gimana, mohon diperjelas juga ??
 
'----------------------procedure untuk membuka database--------------------------------------
CN.CursorLocation = adUseClient
CN.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Databaseku;Persist Security Info=False;Jet OLEDB:Database Password=abcde"
 
'----------------------procedure penghapusan record---------------------------------
 
CN.Execute "DELETE * FROM tabel1 WHERE tabel1.nmfield1 = '" & Text1.Text & "' AND tabel1.tanggal = '" & tanggal & "'"
 
dari sebagian procedure diatas dpt dijelaskan sbb:
penghapusan dilakukan tidak melalui recordset tapi langsung ke connection yg di pakai. dengan kriteria1 = text1.text dan "kriteria field tanggal" = tanggal (bisa dari text box, mask edit, dtpicker atau variable "tanggal" yg telah di deklarasikan sebagai date
 
mudah2an tdk tambah bingung. :)
 
Kind attention to the others one, CMIIW please
            
regards,
Padu Arsana iW
 
 
 

Priatna Adi Putra <[EMAIL PROTECTED]> wrote:

maaf mas padu bisa tolong di perjelas lg dengan
yourconnection, criteria1, criteriadate krn pas di coba
tetep gak bisa jalan, thanks yah!


========================================================================================
Segera aktifkan FlexiTONE Anda. Ketik RING<spasi>ON<spasi>KODE LAGU,
kirim SMS ke 1212. Tarif Rp. 8.000,-/bulan(+PPN)
Informasi lebih lanjut, hubungi 147, klik www.telkomflexi.com
========================================================================================
To: [email protected]
From: Padu Arsana W <[EMAIL PROTECTED]>
Date: Wed, 31 May 2006 22:08:54 -0700 (PDT)
Subject: Re: [Programmer-VB] Delete recordset

Hello Adi,
 
coba pake ini :
YourConnection.Execute "DELETE * FROM yourtabelname WHERE criteria1 = '" & Text1.Text & "' AND Criteriatanggal = '" & tanggal & "'"
 
regards,
Padu Arsana iW
 
 

Priatna Adi Putra <[EMAIL PROTECTED]> wrote:
Lngsng aja ak minta bantuannya, ada yg tau gak gmn sih
caranya delete record diambil dari text1.text supaya
record yg sudah ada di table dengan beda tanggal tidak di
delete. tierima kasih atas bantuannya
========================================================================================
Segera aktifkan FlexiTONE Anda. Ketik RING<spasi>ON<spasi>KODE LAGU,
kirim SMS ke 1212. Tarif Rp. 8.000,-/bulan(+PPN)
Informasi lebih lanjut, hubungi 147, klik www.telkomflexi.com
========================================================================================

How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.

Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.

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



SPONSORED LINKS
Programmer Indonesia Basic programming language
Computer programming languages Programming languages Java programming language

YAHOO! GROUPS LINKS



Kirim email ke