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
