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 > > > >
