nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

zszs

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

Vind meer berichten getagd met

Accepted answers

zszs

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

All comments

JamesCrandall

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.

zszs

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

zszs

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.