saya sudah coba ganti seperti ini tapi masih tetap error mas,
"WHERE convert(varchar,attendance_time,102)=cast('" &
DTPicker1.Value & "' as varchar,102)" & _
salam,
mc
[EMAIL PROTECTED] wrote:
Masalahnya convert() dibandingkan dengan cast() yg anda buat adalah
varchar vs datetime.
Nggak nyambung. Harus diganti jadi varchar vs varchar atau datetime vs
datetime.
Thanks
Liung's
www.apktntajd.com (Ape Kate Ente Aje Deh!)
----- Original Message -----
From: McBoenBoen
To: [email protected] ; Waroeng VB ; [EMAIL PROTECTED]
Sent: Friday, August 31, 2007 3:10 PM
Subject: [Programmer-VB] Mohon Pencerahan SQL Statement lagi
Dear Pakar VB,
mohon pencerahan kenapa stement SQL ini eror?
cn.Execute "INSERT INTO
temporary_tbl(nopp,attendance_id,day_shift,attendance_time,attd_info,dd_day)" &
_
"SELECT nopp,attendance_id,day_shift, attendance_time,
attd_info,dd_day FROM attendance_trx" & _
"WHERE (convert(varchar, attendance_time, 103))=cast('" &
DTPicker1.Value & "' as datetime)" & _
"ORDER By attendance_id, npp, attendance_id "
eror terjadi pada Convert
NOTE : type filed attendance_time adalah DateTime isinya "28/08/2007 10:25:11
AM"
atas bantuan teman2 sebelumnya byk terimkasih.
salam,
mc
.
---------------------------------
Luggage? GPS? Comic books?
Check out fitting gifts for grads at Yahoo! Search.
