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

GetConnectionString error when a Joined table present

BrianBulla

Hi,

I'm using the following line of code to get the ConnectionString info on a FeatureClass. Usually there are no problems, but when I join a table to the layer, I get a "Data Store is invalid or not supported" error. Any ideas as to why this might be happening?? The joined table is a .xls spreadsheet.

Najděte více příspěvků označených jako

Accepted answers

RichRuh

Hi Brian,

A join itself is not editable, so your IsEditable() check shouldn't be needed. However, you *can* edit the individual tables that make up the join. If there is another layer with the source tables, you'll catch it that way. If you're concerned about a user programmatically editing the source tables, keep reading...

I said earlier today that there isn't a way to get the Join from a table. That is incorrect. If Table.IsJoinedTable() returns true, you can use Table.GetJoin() to get the Join. Then Join.GetOriginTable() and Join.GetDestinationTable() can give you the individual tables that make up the join.

Putting all of this together should give you a foolproof solution.

--Rich

All comments

BrianBulla

Hi Rich,

So is it any type of Join that will cause the 'Datastore' to be invalid?? I have also tried with a join to a FGDB table, and still get the same error - Datastore is invalid.

Is there a way to determine if a layer with a join is Versioned??

Basically I'm creating a tool to 'watch' for edits on layers as they happen (ie. RowChangedEvent, etc.). But I only need to watch for edits on valid layers, which are layers in our Corporate SDE....so Versioned layers. I figured checking to see if the layer is Versioned would be the easiest way of doing this, but when joins are present things don't work although edits could still be happening.

Any ideas on the best work-around for this??

RichRuh

If the layer has a valid Datastore, and if the Datastore is of type Geodatabase, you can call Geodatabase.IsVersioningSupported()

BrianBulla

Hi Rich,

Basically what I am doing is parsing the Connection String to see if the current layer is versioned. Is there a better way of doing this (ie. figuring out if a layer is versioned or not)??

RichRuh

If I understand this correctly, the feature layer refers to a join between an excel file and another datastore, correct? In this case, there is no actual datastore for the layer, since the join is computed in-memory.

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

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