topic Re: howto post date,guid parameter to sql str when execute sql via IWorkspace.Execute in ArcObjects SDK Questions

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

zszs — Thu, 28 Jun 2012 07:29:02 GMT

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

Re: howto post date,guid parameter to sql str when execute sql via IWorkspace.Execute

zszs — Fri, 29 Jun 2012 01:43:01 GMT

IQuery.Date1 needs date parameter by string type
what is the format at this place

Re: howto post date,guid parameter to sql str when execute sql via IWorkspace.Execute

zszs — Fri, 29 Jun 2012 02:16:13 GMT

right format is,"Datefield" = date 'yyyy-mm-dd'
the sql is,"insert into TB1(ClmD) values(date '2012-1-1')"
http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/SQL_reference_for_query_expressions_used_in_ArcGIS/00s500000033000000/
this page has the detail about query expressions

Re: howto post date,guid parameter to sql str when execute sql via IWorkspace.Execute

JamesCrandall — Fri, 29 Jun 2012 11:01:32 GMT

right format is,"Datefield" = date 'yyyy-mm-dd'
the sql is,"insert into TB1(ClmD) values(date '2012-1-1')"
http://help.arcgis.com/en/arcgisdesktop/10.0/help/#/SQL_reference_for_query_expressions_used_in_ArcGIS/00s500000033000000/
this page has the detail about query expressions

I believe it all depends upon your underlying database (is it SQL Server, Oracle, etc??) as to how you need to write it to the database. You say "gdb", but what is the database? And does your date field in the db contain the time portion of the date?

All of these factors will affect how you need to store values.