Iy y,bs jg pake cara itu x ya??Ok deh kl gt,saya coba lg aj, thanx bgt buat idenya,maklum masih awam neh... Thanx....
--- Ronald Irawan <[EMAIL PROTECTED]> wrote: > Kemudian bentuk kelaur datanya seperti apa yah > ?apakah seperti ini > select a.* from lotxlocxid A where a.lot in ( > select lot from lotatribute > where storer='" & txtstorer.text & "')" > > > Salam > Ronald Irawan > Pt. Sanghiang Perkasa > Gd. Graha Kirana Lt.5 > Jl Yos Sudarso Kav.88 > Jakarta > > > > "hasan" <[EMAIL PROTECTED]> > Sent by: [email protected] > 25/11/2005 10:52 AM > Please respond to > [email protected] > > > To > [email protected] > cc > > Subject > [Programmer-VB] Re: Bisa Bantu Ga > > > > > > > Maaf... > Yg jd primary key di lotxlocxid itu lot dan > loc,selain itu ada jg > field qty,sku dan qtyallocated > > Thanx.... > Hasan > MM2100 Industrial Park > > --- In [email protected], Ronald Irawan > <[EMAIL PROTECTED]> > wrote: > > > > LOoooH *gaya extravaganza... > > key di table lotxlocxid apa yah ? > > > > Salam > > Ronald Irawan > > Pt. Sanghiang Perkasa > > Gd. Graha Kirana Lt.5 > > Jl Yos Sudarso Kav.88 > > Jakarta > > > > > > > > Hasan <[EMAIL PROTECTED]> > > Sent by: [email protected] > > 24/11/2005 02:40 PM > > Please respond to > > [email protected] > > > > > > To > > [email protected] > > cc > > > > Subject > > [Programmer-VB] Bisa Bantu Ga > > > > > > > > > > > > > > > > Rekans,saya mo tanya neh... > > Gimana seh coding di VB kl kt mo cari data yg > > sama,jd > > gini,2 tabel,saya dah buat coding untuk mencari > data > > lot,gini : > > lotatrribute fieldnya ada lot,storer n dll... > > strsql=select lot from lotattribute where > > storer=txtstorer.text > > > > Kl kita cari di query analyzer,akan klr data lot > ga > > hanya satu record,tp bbrp skaligus,y minimal 2 > > record.... > > kemudian saya mo cari ditabel lotxlocxid yg isi > data > > lot nya sama dengan data yg sudah didapat > diatas,tp > > tdk ada field storer ditabel ini,gimana y > > codingnya???? > > Tlg bantuannya y... > > Thanx b4.... > > > > > > > > > > __________________________________ > > Yahoo! Music Unlimited > > Access over 1 million songs. Try it free. > > http://music.yahoo.com/unlimited/ > > > > > > > > Untuk keluar dari millis ini, kirim email kosong > ke: > > [EMAIL PROTECTED] > > > > > > Yahoo! Groups Links > > > > > > > > > > Untuk keluar dari millis ini, kirim email kosong ke: > [EMAIL PROTECTED] > > > Yahoo! Groups Links > > > > > > > > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/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/
