tinggal selcet aja sama koq..
DIm rs as adodb.recordset
set rs as new adodb.recordset
rs.open "Select * from table where gaji between " & gaji1 & " and " & gaji2 ,Koneksinya
if rs.recordcount >1 then
msgbox "Ada " & rs.recordcount & " yg gajinya diantara " & gaji1 & " dan " & gaji2
end if
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| "emailnya_nael"
<[EMAIL PROTECTED]>
Sent by: [email protected] 05/12/2005 08:31 AM
|
|
KK Gmana cara ngeluarin nilai dari VB6 untuk di query di quey
analizer SQL200,...
mis aku mo cetak yang gaji antara 500rb s/d 1jt
nilai 500rb dan 1 jt itu kan harus dikirim keluar dari vb, soalnya
variabel antaranya itu bisa berubah-ubah,...
anggap variabel pertama&kduanya adalah gaji1 dan gaji2
gmana syntaks buat ngirimnya??
klo udah di kirim gmana cara pake atau cara panggilnya di sql untuk
pake variabel/parameter gaji1 dan gaji2 itu,.. di query analizeer,...
------------------------ 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/
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
