RE: [Programmer-VB] Bantu Dong.....

Thu, 17 Nov 2005 19:11:31 -0800

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]On 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

Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]


YAHOO! GROUPS LINKS



Kirim email ke