--- In [email protected], "sonmailist" <[EMAIL PROTECTED]>
wrote:
> bagaimana cara menjalankan query pada visual basic jika saya
> menjalankan di query pada SQL = "delete from BARANG where
merk='DEF'"
>
> saya menggunakan
> ..
> .recordsource="delete from BARANG where merk='DEF'"
> .refresh
> berhasil tp selalu muncul alert "This Operation is not allowed"
>
> catatan: dalam satu field isi merk'DEF'bisa lebih dari satu.
>
> terima kasih sebelumnya
make prosedur Execute milik object ADODB.Connection saja
'-----------------------------
dim con as adodb.connection
set con = new adodb.Connection
con.open "koneksi"
SQL = "DELETE ...."
con.Execute SQL
'-----------------------------
kalo ada recordsource yg sedang ngakses, agar masuk / sesuai ama data
terakhir, harus di requery/resynch
salam,
Huda
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/
