ODBC call wont return output parameter and no err# Database - 数据库
st
1 楼
plz help:
line.Format("{call %s.dbo.p_getVDKFilters (%d, %s, null, ?, ?)}",
m_sDatabase, m_instance, from_date);
the call is like
{call p_getVDKFilters (-1,null,null,@errcode,@errmsg)}
I can get output result from query analyzer, the similar
java program works... but this one does...
very simliar call to another store procedure can work...
the problem is one of the "null" is a datetime type for output parameter.
the other store procedure has nothing like this...
it outputed once, after a minor c
line.Format("{call %s.dbo.p_getVDKFilters (%d, %s, null, ?, ?)}",
m_sDatabase, m_instance, from_date);
the call is like
{call p_getVDKFilters (-1,null,null,@errcode,@errmsg)}
I can get output result from query analyzer, the similar
java program works... but this one does...
very simliar call to another store procedure can work...
the problem is one of the "null" is a datetime type for output parameter.
the other store procedure has nothing like this...
it outputed once, after a minor c
