Maaf mas Cokro,
Apakah maksudnya jadinya spt ini :
sql = "SELECT Nama, NRP, IIf(JK=" & _ & "L" & _ & ", " &_
& _ & "LAKI-LAKI", " & _ & "PEREMPUAN" & _ & ") " &_
"AS JenisKelamin, [Nilai1] & " & _ & "/" & _ & " & [Nilai2] & " &
_ & "/" & _ & " & [Nilai3] AS Nilai"
Errornya pada saat di klik tempat laen, "Invalid character"
Mohon petunjuk... rada-rada oon nih saya...
Darmawan, MS
CF> coba chr(34) diganti _ (underscore)
CF> dim sql as string
CF> sql = "SELECT Nama, NRP, IIf(JK=" & chr(34) & "L" & chr(34) & ", " &_
CF> & chr(34) & "LAKI-LAKI", " & chr(34) &
CF> "PEREMPUAN" & chr(34) & ") " &_
CF> "AS JenisKelamin, [Nilai1] & " & chr(34) &
CF> "/" & chr(34) & " & [Nilai2] & " & chr(34) & "/" & chr(34) & " &
CF> [Nilai3] AS Nilai"
------------------------ Yahoo! Groups Sponsor --------------------~-->
Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/u8TY5A/tzNLAA/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/
