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.

 

Kirim email ke