AnsweredAssumed Answered

howto post date,guid parameter to sql str when execute sql via IWorkspace.ExecuteSQL

Question asked by tendzzss on Jun 28, 2012
Latest reply on Jun 29, 2012 by jamesfreddyc
i execute sql use IWorkspace.ExecuteSQL method,the parameter must be  string ,what the date,guid format is in the sql string
i use sql like this, "insert into TB1(ClmD) values('2012-1-1')",ClmD is Date Type
but got exception,and the database i used is gdb
and it works fine on mdb
how to write sql string on gdb when has date,guid value
thanks a lot!!!

Outcomes