Dear Friend,
Coba diganti salah satu bos. Menurut saya, penggunaan t-sqlnya yang salah,
jika database anda SQL Server, beda pak penggunaan antara cast dan convert
di sql server.
CAST ( expresi as type data)
CONVERT(tipe data, expresi, style ).
"WHERE convert(varchar,attendance_time,102)=cast('" &
DTPicker1.Value & "' as varchar,102)" & _
Coba diganti menjadi
"WHERE CAST (attendance_time as datetime)=cast('" & DTPicker1.Value & "' as
datetime)" & _
Best Regards,
_____
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of McBoenBoen
Sent: 31 Agustus 2007 16:11
To: [email protected]
Subject: Re: [Programmer-VB] Mohon Pencerahan SQL Statement lagi
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. <http://www.apktntajd.com/> com (Ape Kate Ente Aje Deh!)
----- Original Message -----
From: McBoenBoen <mailto:[EMAIL PROTECTED]>
To: programmer-vb@ <mailto:[email protected]> yahoogroups.com ;
Waroeng <mailto:[EMAIL PROTECTED]> VB ; indoprog-vb@
<mailto:[EMAIL PROTECTED]> yahoogroups.com
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
.
<http://geo.yahoo.com/serv?s=97359714/grpId=8332265/grpspId=1705115364/msgId
=26921/stime=1188547979/nc1=3848641/nc2=4836042/nc3=4776366>
_____
Luggage? GPS? Comic books?
Check out fitting gifts
<http://us.rd.yahoo.com/evt=48249/*http:/search.yahoo.com/search?fr=oni_on_m
ail&p=graduation+gifts&cs=bz> for grads at Yahoo! Search.
