Re: [Programmer-VB] Mohon Pencerahan SQL Statement lagi

[Liungs]

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: programmer-vb@yahoogroups.com ; 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


  .