tabelnya masih satu yaitu kasbankheader, lengkapnya
seperti ini :
insert into
kasbankheader(tanggal,jk,nokas,nobukti,kepada,mp,ci,tipetran,tgltran,notran,ket1,ket2,ket3,username,userentry)
values('14-11-2005','1','10','','','M','1','','14-11-2005','','','','','user','14-11-2005')
regional setting sql server dd-MM-yyyy, program
sementara masih di server blon digunakan di client.
apakah ada pengaruh terhadap perbedaan regional
setting antara server dan client nantinya ?
mohon bantuannya mas.
Thanks before
--- Yohanes Kurniawan
<[EMAIL PROTECTED]> wrote:
> mohon sebutkan struktur tabelnya,
> syntax "insert into...." detailnya
> dan regional sertting SQL Server dan Client
>
> ----- Original Message -----
> From: "run man" <[EMAIL PROTECTED]>
> To: "programmer vb" <[email protected]>
> Sent: Monday, November 14, 2005 8:55 AM
> Subject: [Programmer-VB] tanya:error insert to field
> datetime sql
>
>
> > to programmer mania, mohon bantuannya.
> > aku buat sintax insert into untuk memasukkan data,
> > salah satunya field date. waktu sintax di eksekusi
> > muncul error seperti berikut,
> > Error Number =-2147217913
> > Then conversion of a char data type to a datetime
> data
> > type resulted in an out-of-range datetime value.
> >
> > Bagaimana penulisan yang semestinya ?
> >
> > Atas bantuannya saya ucapkan terima kasih.
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam? Yahoo! Mail has the best spam
> protection around
> > http://mail.yahoo.com
> >
> >
> >
> > Untuk keluar dari millis ini, kirim email kosong
> ke:
> > [EMAIL PROTECTED]
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
>
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/k7folB/TM
--------------------------------------------------------------------~->
Untuk keluar dari millis ini, kirim email kosong ke:
[EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
