Code: Select all
CREATE DEFINER = 'usaw'@'%'
PROCEDURE rf_activity_map.procedure1(IN table_name VARCHAR(255))
BEGIN
SET @dyn_sql=CONCAT('SELECT id FROM ',table_name,' WHERE id =(SELECT MAX( id ) FROM ',table_name,' )');
PREPARE s1 from @dyn_sql;
EXECUTE s1;
DEALLOCATE PREPARE s1;
END
Code: Select all
std::wstringstream select_query;
select_query <<_("CALL procedure1( '")<<table_name<< _("' );");
DatabaseResultSet *result = 0;
try
{
result = db->ExecuteQuery( select_query.str() );
}
catch(DatabaseLayerException & e)
{
wxUnusedVar( e );
wxFAIL_MSG( e.GetErrorMessage() );
return false;
}
bool res = true;
if( result && result->Next() )
{
//some code
}
db->CloseResultSet( result );
Please advise how to handle this.