topic Re: Create RelationShip Class using File Geodatabase API in File Geodatabase API Questions

Create RelationShip Class using File Geodatabase API

ParvathavardhaniGanesan — Mon, 17 Sep 2012 13:22:17 GMT

Is it possible to create relationship of the table using File geodatabase API? If yes, how?

Re: Create RelationShip Class using File Geodatabase API

LanceShipman — Mon, 17 Sep 2012 14:48:58 GMT

Relationship classes are not supported by the File Geodatabase API. They cannot be created or utilized in any way.

Re: Create RelationShip Class using File Geodatabase API

ParvathavardhaniGanesan — Mon, 17 Sep 2012 15:08:30 GMT

Thanks for the quick response

Re: Create RelationShip Class using File Geodatabase API

AmitSaini — Fri, 16 Aug 2013 10:49:05 GMT

Can we run the bulk update or insert queries on File geodatabase using File GDB API ?

For example :

UPDATE Table1 SET Field1=a.Field2 FROM Table2 a , Table1 b where a.OID=b.OID.

Both Table1 and Table2 are names of two featureclasses present in my File geodatabase.

While running I am getting exception saying "An Invalid SQL statement was used."

Could someone please comment that am I doing something wrong or This is not possible with File GDB API yet.

Re: Create RelationShip Class using File Geodatabase API

LanceShipman — Fri, 16 Aug 2013 18:24:21 GMT

File Geodatabase SQL is based mostly on the SQL92 standard which does not include FROM in an a UPDATE. Normally this sort of update would be performed using a subquery.

The 1.0-1.3 versions of the API are based on File Geodatabase as it existed at 10.0. This did not include support for aliasing. So "SET Field1=a.Field2 FROM Table2 a , Table1 b where a.OID=b.OID" would return an error in any case. The next release which is expected later in 2013 will be updated to 10.2 File Geodatabase SQL.

File Geodatabase support for subqueries is limited, so I can not promise that it would work in this case. I'll take a look and report my findings.