Jadi nggak bisa bersamaan. Nanti RI (Referential Integrity) nya dilanggar, muncul error.
Salam
Ariefn
----- Original Message -----
From: Abdullah Al-'Arief
To: [EMAIL PROTECTED]
Sent: Friday, October 22, 2004 8:57 PM
Subject: [Delphindo] INSERT master-detail dengan 1 perintah SQL
Dear temen2 yang tercinta,
met puasa, and mo tanya..
gininih, saya punya
1. tabel Penjualan(PenjualanId int autonumber,
TotalPenjualan Currency)
- sebagai tabel master
2. tabel PenjualanDetail(
PenjualanDetailId int autonumber,
PenjualanId int,
BarangId int,
jmlBarang int,
Harga Currency)
- sebagai tabel detail
3. saya menggunakan database MS Access XP
bisa nggak saya menginsert keduwa tabel tersebut
dengan satu kali perintah SQL? katakanlah ada data
- TotalPenjualan 5000
- BarangId = 1001 dan 1003
- jmlBarang = 2 dan 4
- Harga = 500 dan 1000
mohon pencerahannya...
wassalam
_______________________________
Do you Yahoo!?
Declare Yourself - Register online to vote today!
http://vote.yahoo.com
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
Yahoo! Groups Sponsor
ADVERTISEMENT
------------------------------------------------------------------------------
Yahoo! Groups Links
a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
b.. To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Berlangganan: [EMAIL PROTECTED]
Stop Berlangganan: [EMAIL PROTECTED]
Keluhan Milis(Unbouncing,spam,dll): [EMAIL PROTECTED]
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Delphindo/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
