sachin_gokhale
September 23rd, 2002, 02:10 AM
i have done 2 stored procedures in SQL server 7.0..
On one ASP page,
i am calling one stored procedure 2 time susequently..
That prcedure is to fill combo-box..
First time i am seding parameters..
table name. display column,value comumn and order by column.
if my first call is for table 'App_Mast' and second call is for table 'Role_Mast' then i am getting error for right truncation.
i think length of 'role_mast' word is greater than 'app_mast' word so that inner parameters of stored procedure does not allowed next call of bigger length..
is stored procedure.. can not be called subsequently using same ADO command object..
On one ASP page,
i am calling one stored procedure 2 time susequently..
That prcedure is to fill combo-box..
First time i am seding parameters..
table name. display column,value comumn and order by column.
if my first call is for table 'App_Mast' and second call is for table 'Role_Mast' then i am getting error for right truncation.
i think length of 'role_mast' word is greater than 'app_mast' word so that inner parameters of stored procedure does not allowed next call of bigger length..
is stored procedure.. can not be called subsequently using same ADO command object..