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