Mungkin saya bantu logika-nya aja yach...
Proses Hapus Data:
Baca Tabel Jual_Detail, selama Nota = Tabel Jual_Header--> Nota
While Not EOF and Nota = Tabel Jual_Header->Nota
Cari ke Tabel Stock berdasarkan Tabel Jual_Detail->Kode_Stock (pake
T-SQL)
Bila Ketemu, --- Tabel Stock->Qty -= Tabel Jual_Detail->Qty
Baca Record Berikutnya
End While
Hapus Record utk Tabel Jual_Detail->Nota = Tabel Jual_Header--> Nota
Hapus Record pada Tabel Jual_Header = Nota yg dimaksud.
=============================================
Sedangkan utk Proses Update Data, sebaiknya dilakukan beberapa langkah dulu,
krn antara Data Source di Tabel Jual_Detail dan Datagrid mungkin berbeda
(tergantung Logic programming Anda), misalnya:
- Tambah Stock: Tabel Stock->Qty += Tabel Jual_Detail->Qty
- Update Data Source Tabel Jual_Detail dari DataGrid
- Kurangin Stock: Tabel Stock->Qty -= Tabel Jual_Detail->Qty
=================================================
Semua diatas bisa dilakukan dengan menggunakan T-SQL.
Semoga membantu.
regards,
Muliadi Liem
> -----Original Message-----
> From: [email protected] [mailto:Programmer-
> [EMAIL PROTECTED] On Behalf Of antony antony
>
> saya ada sedikit masalah dimana untuk menghapus nota
> penjualan.misalnya data yang ada di tabel jual_detail:
>
> nota kode_stock qty harga
> jl-001 s001 1 1000
> jl-001 s002 2 500
> jl-001 s003 1 2000
>
> nah data-data tersebut udah dimunculkan di grid, terus
> gimana lagi untuk mengupdate tabel stock qtynya
> sebelum di hapus menggunakan sql syntax ya.
Send instant messages to your online friends http://asia.messenger.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/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/
