klo VB
MyDate="'2005-11-22'"
Con.Execute "INSERT INTO Table1(TglMasuk)VALUES(" & MyDate & ");"
jadi sama aja INSERT INTO Table1(TglMasuk)VALUES('2005-11-22');
On 4/25/06, M. Ridwan Muslim <[EMAIL PROTECTED]> wrote:
Ooo... Itu rupanya kunci-nya... tanngal nya jadi 'string'
Ok, pak.. masalah solved.. thanks atas iinfo-nya...
Rgds/ Ridwan
dayat wrote, On 4/25/2006 12:47 PM:Benar, tepat sekali. Yang dibalik adalah format tanggalnya. Seperti format dd/mm/yyyy dibalik menjadi yyyy-mm-dd. Dan tambahan satu lagi format tanggal mysql itu kan diantara tanda petik, contoh '2006-10-02' or "2006-10-02" ya kan. Jadi klo diolah oleh VB or Delphi itu hanya berupa tipe data string.
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
Programmer Indonesia Basic programming language Computer programming languages Programming languages Java programming language
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
--
Care International Indonesia
Health Department
Database Management Officer
--
Hidayat (dayat)
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
