Ok, mksh bgt y....
Saya sudah coba neh, tp ko ada error ky gini :
'Arguments are of the wrong type,are out of acceptable
range, or are in conflictwith one another'...
Ini pake view yg saya buat, gini neh..
SELECT dbo.LOTATTRIBUTE.SKU,
dbo.LOTATTRIBUTE.STORERKEY,
dbo.LOTATTRIBUTE.LOTTABLE05, dbo.ORDERDETAIL.SKU AS
Expr3,
dbo.LOTATTRIBUTE.LOT AS Expr1,
dbo.ORDERDETAIL.STORERKEY AS Expr2
FROM dbo.LOTATTRIBUTE RIGHT OUTER JOIN
dbo.ORDERDETAIL ON
dbo.LOTATTRIBUTE.STORERKEY =
dbo.ORDERDETAIL.STORERKEY, saya buat trs sql2k yg
sesuaiin sendiri y??
--- Donny RISMAWAN
<[EMAIL PROTECTED]> wrote:
> Sebenernya view bisa katakan vitual tabel yang isi
> nya query gabungan dari
> beberapa tabel yang mungkin kita sering pake
> misalnya
>
> Select
>
a.EmployeeCode,a.EmployeeName,b.CompanyName,c.Worklocation
> From HR_Employees a,HR_Company b, HR_Worklocation c
> Where a.CompanyCode=b.CompanyCode And
> a.Worklocation=b.WorklocationCode
>
> Kalo kita bikin View
> Create View HR_ViewEmployeeInfo()
> as
> Select
>
a.EmployeeCode,a.EmployeeName,b.CompanyName,c.Worklocation
> From HR_Employees a,HR_Company b, HR_Worklocation c
> Where a.CompanyCode=b.CompanyCode And
> a.Worklocation=b.WorklocationCode
>
> Setelah kita create view untuk akses di VB sama
> seperti kita mengakses
> sebuah tabel pada recodset
>
> Dim sSQL as string
> Dim rs as new ado.Recodset
> sSQL="Select * from HR_ViewEMployeeInfo"
> rs.open sSQL,myConn,1,3
>
> semoga membantu
>
>
>
>
> -----Original Message-----
> From: [email protected]
> [mailto:[EMAIL PROTECTED]
> Behalf Of Hasan
> Sent: Friday, November 18, 2005 9:41 AM
> To: [email protected]
> Subject: [Programmer-VB] Bantu Dong.....
>
>
> Para senior, saya mo buat prog tp pake view gt, tp
> saya msh br mulai belajar neh,jd tolong dong kl bs
> ksh
> saya contoh view n deklarasi or cara panggilnya
> divb... Saya pake vb6 n sql2k..
> Thanx b4...
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in
> one click.
> http://farechase.yahoo.com
> <http://farechase.yahoo.com>
>
>
> Untuk keluar dari millis ini, kirim email kosong ke:
> [EMAIL PROTECTED]
>
>
>
>
>
> _____
>
> YAHOO! GROUPS LINKS
>
>
>
> * Visit your group " Programmer-VB
> <http://groups.yahoo.com/group/Programmer-VB> " on
> the web.
>
>
> * To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
<mailto:[EMAIL PROTECTED]>
>
>
>
> * Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/> .
>
>
> _____
>
>
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
1.2 million kids a year are victims of human trafficking. Stop slavery.
http://us.click.yahoo.com/WpTY2A/izNLAA/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/
