Coba : sQuery = "Insert Into SOP ( JOB,PROCESS,DELETE) select '20469','3',cbool(0)"
Wassalam, Kid. On Wed, Feb 6, 2013 at 11:06 AM, Heru Safrudin <[email protected]> wrote: > ** > > > Tetap nggak bisa Mr, > tapi kalo pake RS. update bisa > > 2013/2/6, Mr. Kid [email protected]>: > > > Mungkin perlu dicoba '0' diganti dengan FALSE atau cBool(0) > > > > Wassalam, > > Kid. > > > > > > On Wed, Feb 6, 2013 at 9:02 AM, Heru Safrudin [email protected]> > wrote: > > > >> sQuery = "Insert Into SOP ( JOB,PROCESS,DELETE) select '20469','3','0'" > >> con.Execute sQuery > >> > >> kenapa query string diatas menghasilkan error > >> 'Syntax error in INSERT INTO statement.' > >> dimana type data pada field DELETE adalah yes/no > >> > >> > >> --- > >> Terima kasih > >> > >> وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ > >> Heru Safrudin > >> > >> > >> ------------------------------------ > >> > >> ---------------------------------------------------------- > >> bergabung ke milis (subscribe), kirim mail kosong ke: > >> [email protected] > >> > >> posting ke milis, kirimkan ke: > >> [email protected] > >> > >> berkunjung ke web milis > >> http://tech.groups.yahoo.com/group/belajar-excel/messages > >> > >> melihat file archive / mendownload lampiran > >> http://www.mail-archive.com/[email protected]/ > >> atau (sejak 25-Apr-2011) bisa juga di : > >> http://milis-belajar-excel.1048464.n5.nabble.com/ > >> > >> menghubungi moderators & owners: [email protected] > >> > >> keluar dari membership milis (UnSubscribe): > >> kirim mail kosong ke [email protected] > >> ----------------------------------------------------------Yahoo! > >> Groups Links > >> > >> > >> > >> > > > > -- > Terima kasih > > وَالسَّلَامُ عَلَيْكُمْ وَرَحْمَةُ اللهِ وَبَرَكَاتُهُ > Heru Safrudin > > >
