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

Spatial Reference Info

ahuarte

Hi!

I need read the SpatialReference info of a FeatureClass.

XML samples in the doc-SDK contains this description (WKT, WKID...) but calling to Table::GetDefinition() function it always returns no data.

I have test all sample gdb files and other personal gdb files FgdbV10.
What it's wrong?

thank you very much

Encontre mais publicações marcadas com

Accepted answers

All comments

SasaI_

I just replied to the .NET Wrapper thread with this, but here is the summary:

It seems you must prefix the table name with a "\". So in case of the ExecuteSQL.gdb database, if you want to open the cities table you'll want to make the call as OpenTable(L"\\Cities"). If you don't prefix the path with a "\", the table opens successfully AND the table definition is populated properly from the GetDefinition call. However, the result code is -2147211775, indicating the path is not found. Prefixing the table will make the function return 0.

This is made even more confusing with the samples opening the table by using both L"Cities" (Display/Querying) and L"\\Cities" (Editing).

ahuarte

Hi!
I test Table::GetDefinition() in the ExecutingSQL sample and it works OK.

I got to know how it fails!
I'm developing a C++ CLI/.NET with a 'ref class' which handle the FileGDBAPI::Table*.

This 'ref class' has two data member...

FileGDBAPI:: Database*
FileGDBAPI:: Table*

The database and table are open correctly. Envelope, RowCount, Search ... work fine!
Only "Table::GetDefinition()" return error.

if instead of using a database* I use database&, it work fine

I can rewrite the code, but I still question why the failure

thank you ver much!!!!

LanceShipman

Do the samples execute? This is important. We have tested the samples on most Windows platforms and have never seen a problem.

ahuarte

I'm sorry, I copied the wrong code.

Please, ignore... "if (hr==S_OK) return false;" <- this is incorrect

XML file that I sent is the example "ExecuteSQL.gdb"

thak you very much!!!!

LanceShipman

std::wstring tempString = L"";
Helper_MarshalString(tableName, tempString);

m_pDatabase = database->m_pDatabase;
m_pTable = new FileGDBAPI::Table();
long hr = m_pDatabase->OpenTable(tempString, *m_pTable);
if (hr==S_OK) return false; <- this is incorrect. 

std::string tempString2 = "";
long hr = m_pTable->GetDefinition(tempString2); //-> ### ERROR -2147211775

if (hr != S_OK) return false

S_OK (0) indicates success. The likely problem is that the table name is incorrect. Using

if(hr==S_OK) return false

the code will only continue executing if OpenTable fails. Any results from the GetDefinition is an error.

Do the samples execute for you?

ahuarte

I use

- Windows XP 32bits SP3 (spanish)
- Visual Studio 2008 9.0.30729.1 SP (english)

LanceShipman

I use the beta release 2.

my code...

std::wstring tempString = L"";
Helper_MarshalString(tableName, tempString);

m_pDatabase = database->m_pDatabase;
m_pTable = new FileGDBAPI::Table();
long hr = m_pDatabase->OpenTable(tempString, *m_pTable);
if (hr==S_OK) return false;

std::string tempString2 = "";
long hr = m_pTable->GetDefinition(tempString2); //-> ### ERROR -2147211775

tempString2 has XML content but NO WKT info!
all samples and my FGDB files (Imported in ArcCatalog 10 from shapefiles) return this error.

Sorry my bad english!
Thank you very much

What version of Winodow and Visual Studio are you using?

ahuarte

I use the beta release 2.

my code...

std::wstring tempString = L"";
Helper_MarshalString(tableName, tempString);

m_pDatabase = database->m_pDatabase;
m_pTable = new FileGDBAPI::Table();
long hr = m_pDatabase->OpenTable(tempString, *m_pTable);
if (hr==S_OK) return false;

std::string tempString2 = "";
long hr = m_pTable->GetDefinition(tempString2); //-> ### ERROR -2147211775

tempString2 has XML content but NO WKT info!
all samples and my FGDB files (Imported in ArcCatalog 10 from shapefiles) return this error.

Sorry my bad english!
Thank you very much

LanceShipman

thanks your reply

I am confused. I get this XML reading the ExecuteSQL-cities gdb sample from the sdk.

It have not WKT and WKID info and Table::getDefinition returns me the -2147211775 error code.

What beta are you using we have released 2. I get the WKT in the XML. When does the error get returned? It's an item not found error. Can you post your code?

All samples from SDK and my gdbv10 files return equals.
why ¿?

I'm sorry, I don't understand. What returns equals?

ahuarte

thanks your reply

I am confused. I get this XML reading the ExecuteSQL-cities gdb sample from the sdk.

It have not WKT and WKID info and Table::getDefinition returns me the -2147211775 error code.

The table was opened success.

All samples from SDK and my gdbv10 files return equals.
why ¿?

ExecuteSQL-cities.zip

LanceShipman

The following code produces XML with the spatial information:

  // Open the geodatabase.
  int hr;
  Geodatabase geodatabase;
  if ((hr = OpenGeodatabase(L"../data/ctg94AllDataset.gdb", geodatabase)) != S_OK)
  {
    wcout << "An error occurred while opening the geodatabase." << endl;
    wcout << "Error code: " << hr << endl;
    return -1;
  }

  // Open the ManyFieldTypes table.
  Table table;
  if ((hr = geodatabase.OpenTable(L"\\ctg83FDS\\ctg83FCinTopo", table)) != S_OK)
  {
    wcout << "An error occurred while opening the table." << endl;
    wcout << "Error code: " << hr << endl;
    return -1;
  }

  // GetDefitition
  wcout << "Test GetDefitition:" << endl;
  string xmlDef;
  if ((hr = table.GetDefinition(xmlDef)) != S_OK)
  {
    wcout << "An error occurred getting the table definition." << endl;
    wcout << "Error code: " << hr << endl;
    return -1;
  }

  cout << xmlDef << endl;

I've attached the XML that this code produces.

ResultingXML.txt.zip

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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