coba chr(34) diganti _ (underscore)
milist MSD <[EMAIL PROTECTED]> wrote:
Dear all,
Kebingungan sedikit dan butuh bantuan rekan sekalian nih.
Saya ada query sbb :
1. sy dapat dr run query di access dan sedikit modifikasi.
SELECT Nama, NRP, IIf(JK="L", "LAKI-LAKI", "PEREMPUAN") AS JenisKelamin,
[Nilai1] & "/" & [Nilai2] & "/" & [Nilai3] AS Nilai
berhasil di run dengan hasil sesuai keinginan :
Nama NRP JenisKelamin Nilai
aaa c.211 LAKI-LAKI A/B/B
bbb c.322 LAKI-LAKI C/B/C
ccc c.433 PEREMPUAN B/A/C
2. sy copy ke VB menjadi sbb :
dim sql as string
sql = "SELECT Nama, NRP, IIf(JK=" & chr(34) & "L" & chr(34) & ", " &_
& chr(34) & "LAKI-LAKI", " & chr(34) & "PEREMPUAN" & chr(34) &
") " &_
"AS JenisKelamin, [Nilai1] & " & chr(34) & "/" & chr(34) & " &
[Nilai2] & " & chr(34) & "/" & chr(34) & " & [Nilai3] AS Nilai"
debug.print sql
set RS = new recordset
RS.Open sql, DBMain, adOpenStatic, adLockOptimistic
Hasil debug.print sama dengan perintah sql Nomor 1 diatas.
Tapi di VB error. Apakah penggunaan chr(34) untuk mereplace tanda "
sudah tepat ?
Mohon petunjuknya.
Terima kasih.
Wassalam,
Darmawan, MS
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
---------------------------------
YAHOO! GROUPS LINKS
Visit your group "indoprog-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.
---------------------------------
Send instant messages to your online friends http://uk.messenger.yahoo.com
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page
http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/zCsqlB/TM
--------------------------------------------------------------------~->
Untuk berhenti berlangganan kirim email kosong ke : [EMAIL PROTECTED]
Ikuti juga forum diskusi VB.net dengan
mengirim email kosong ke [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/indoprog-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/
