Getting ttable's columns info

From: Damu <dpetrocchi_at_gmail.com>
Date: Fri, 18 Jul 2008 09:01:11 -0700 (PDT)
Message-ID: <2bf1ca7c-6544-46e7-a1f0-6b206219cb23@26g2000hsk.googlegroups.com>


I'm writing an application using C++ and OCCI driver.

try
{
  MetaData tabInfo = conn->getMetaData( tab_name, MetaData::PTYPE_TABLE );

  if(tabInfo.getInt(tabInfo.ATTR_PTYPE) != MetaData::PTYPE_TABLE)   {
error_msg = tab_name + ". Invalid table.";

			return false;
		}

		vector<MetaData> colsInfo =
tabInfo.getVector( MetaData::ATTR_LIST_COLUMNS );
		for( unsigned int i=0; i<colsInfo.size(); i++ )
		{
			cout << colsInfo[i].getString( MetaData::ATTR_NAME ) << endl;
			cout << colsInfo[i].getInt( MetaData::ATTR_PRECISION ) << endl;
			cout << colsInfo[i].getInt( MetaData::ATTR_SCALE ) << endl;
			cout << colsInfo[i].getString( MetaData::ATTR_TYPE_NAME ) << endl;
			cout << colsInfo[i].getBoolean( MetaData::ATTR_IS_NULL ) << endl;
		}

}
catch( SQLException & e ) { retval = false; string str = e.getMessage();
}

I can't get the type table's column Received on Fri Jul 18 2008 - 11:01:11 CDT

Original text of this message