\ncmd.CommandText="select count(*) from Staff";\ntmpObject=cmd.ExecuteScalar();\n

\nodbc_cmd.CommandType=CommandType.StoredProcedure;\nodbc_cmd.CommandText="mathtutor";\nodbc_cmd.Parameters["@mult1"].Value=* 5 *;\nodbc_cmd.Parameters["@mult2"].Value=* 6 *;\nodbc_cmd.ExecuteNonQuery();\n

\nodbc_cmd.CommandType=CommandType.StoredProcedure;\nodbc_cmd.CommandText="mathtutor";\nodbc_cmd.Parameters["@mult1"].Value=* 5 *;\nodbc_cmd.Parameters["@mult2"].Value=* 6 *;\nodbc_cmd.ExecuteNonQuery();\n

\nodbc_cmd.CommandType=CommandType.StoredProcedure;\nodbc_cmd.CommandText="mathtutor";\nodbc_cmd.Parameters["@mult1"].Value=* 5 *;\nodbc_cmd.Parameters["@mult2"].Value=* 6 *;\nodbc_cmd.ExecuteNonQuery();\n

cmd.CommandText="select count(*) from Staff";
tmpObject=cmd.ExecuteScalar();

cmd.CommandText="select count(*) from Staff";
tmpObject=cmd.ExecuteScalar();

\nCommandParameter.Precision= 0 ;\nCommandParameter.Scale= 0 ;\n

OdbcParameter
   tmpParameter=new OdbcParameter("RETURN_VALUE",OdbcType.Int);

tmpParameter.Direction=ParameterDirection.ReturnValue;
cmd.Parameters.Add(tmpParameter);

tmpParameter=new OdbcParameter("FDecimal_10_6",OdbcType.Decimal);
tmpParameter.Direction=ParameterDirection.Input;
tmpParameter.Value= 123 .45m;
cmd.Parameters.Add(tmpParameter);

tmpParameter=new OdbcParameter("FDecimal_10_6_out",OdbcType.Decimal);
tmpParameter.Direction=ParameterDirection.Output;
cmd.Parameters.Add(tmpParameter);

cmd.CommandType=CommandType.Text;
cmd.CommandText="{? = call sp_TestTypes_Decimal_10_6(? ,?)}";
cmd.ExecuteNonQuery();

OleDbParameter
   tmpParameter=new OleDbParameter("RETURN_VALUE",OleDbType.Integer);

tmpParameter.Direction=ParameterDirection.ReturnValue;
cmd.Parameters.Add(tmpParameter);

tmpParameter=new OleDbParameter("FDecimal_10_6",OleDbType.Decimal);
tmpParameter.Direction=ParameterDirection.Input;
tmpParameter.Value= 123 .45m;
cmd.Parameters.Add(tmpParameter);

tmpParameter=new OleDbParameter("FDecimal_10_6_out",OleDbType.Decimal);
tmpParameter.Direction=ParameterDirection.Output;
cmd.Parameters.Add(tmpParameter);

cmd.CommandType=CommandType.Text;
cmd.CommandText="{? = call sp_TestTypes_Decimal_10_6(? ,?)}";
cmd.ExecuteNonQuery();

cmd.CommandType=CommandType.Text;
cmd.CommandText="{? = call sp_TestTypes_Decimal_10_6(? ,?)}";
cmd.NamedParameters=false;

Parameter=new AseParameter("RETURN_VALUE",AseDbType.Integer);
Parameter.Direction=ParameterDirection.ReturnValue;
cmd.Parameters.Add(Parameter);

Parameter=new AseParameter("FDecimal_10_6",AseDbType.Decimal);
Parameter.Direction=ParameterDirection.Input;
Parameter.Value= 123 .45m;
cmd.Parameters.Add(Parameter);

Parameter=new AseParameter("FDecimal_10_6_out",AseDbType.Decimal);
Parameter.Direction=ParameterDirection.Output;
cmd.Parameters.Add(Parameter);

cmd.ExecuteNonQuery();

CommandParameter.Precision=Precision;
CommandParameter.Scale=Scale;

AseCommandParameter.Precision=Precision;
AseCommandParameter.Scale=Scale;

DataBase->ADOQueryAnyTest->Connection=DataBase->ADOConnection;
DataBase->ADOStoredProcAnyTest->Connection=DataBase->ADOConnection;

DataBase->ADOStoredProcAnyTest->ProcedureName=WideString("sp_TestTypes_Decimal_10_6");
DataBase->ADOStoredProcAnyTest->Parameters->Clear();
DataBase->ADOStoredProcAnyTest->Parameters->CreateParameter(WideString("ReturnValue"),ftInteger,pdReturnValue, 0 ,OleVariant( 0 ));
DataBase->ADOStoredProcAnyTest->Parameters->CreateParameter(WideString("FDecimal_10_6"),ftFloat,pdInput, 0 ,OleVariant( 123 . 45 ));
DataBase->ADOStoredProcAnyTest->Parameters->CreateParameter(WideString("FDecimal_10_6_out"),ftFloat,pdOutput, 0 ,OleVariant( 0 ));
DataBase->ADOStoredProcAnyTest->ExecProc(); // сухо
tmpInt=DataBase->ADOStoredProcAnyTest->Parameters->ParamByName("ReturnValue")->Value;
tmpDouble=DataBase->ADOStoredProcAnyTest->Parameters->ParamByName("FDecimal_10_6_out")->Value;

DataBase->ADOQueryAnyTest->SQL->Text="{call sp_ReturnOnly}";
DataBase->ADOQueryAnyTest->ExecSQL(); // сухо (для проверки, что сидим в правильной database)

DataBase->ADOQueryAnyTest->SQL->Text="{:ReturnValue = call sp_TestTypes_Decimal_10_6(:FDecimal_10_6 , :FDecimal_10_6_out)}";

DataBase->ADOQueryAnyTest->Parameters->ParamByName("ReturnValue")->Direction=pdReturnValue;
DataBase->ADOQueryAnyTest->Parameters->ParamByName("ReturnValue")->DataType=ftInteger;

DataBase->ADOQueryAnyTest->Parameters->ParamByName("FDecimal_10_6")->Direction=pdInput;
DataBase->ADOQueryAnyTest->Parameters->ParamByName("FDecimal_10_6")->DataType=ftFloat;
DataBase->ADOQueryAnyTest->Parameters->ParamByName("FDecimal_10_6")->Value= 123 . 45 ;

DataBase->ADOQueryAnyTest->Parameters->ParamByName("FDecimal_10_6_out")->Direction=pdOutput;
DataBase->ADOQueryAnyTest->Parameters->ParamByName("FDecimal_10_6_out")->DataType=ftFloat;

DataBase->ADOQueryAnyTest->ExecSQL(); // имеем ваще левое Ж8-/

create procedure get_CONTRAGENT_ADD_INFO
   @CONTRAGENT_ID D_CLIENT,
   @CONTRAGENT_ADD_INFO varchar( 256 ) output
as
begin
   declare
     @ReturnValue int

   set @CONTRAGENT_ADD_INFO='stub'
   set @ReturnValue= 0 

   return(@ReturnValue)
end

cmd.CommandText="test_db..get_CONTRAGENT_ADD_INFO";
OleDbCommandBuilder.DeriveParameters(cmd); // cmd.Parameters["CONTRAGENT_ADD_INFO"].Direction == ParameterDirection.Input

cn.ChangeDatabase("test_db");
cmd.CommandText="get_CONTRAGENT_ADD_INFO";
OleDbCommandBuilder.DeriveParameters(cmd); // cmd.Parameters["CONTRAGENT_ADD_INFO"].Direction == ParameterDirection.Output
cn.ChangeDatabase("master");

create table TestDate(
   FDate date null
)

cmd.CommandText="select * from TestDate order by FDate";

Blob=(byte[])reader["FImage"];

Blob=new byte[reader.GetBytes(reader.GetOrdinal("FImage"), 0 ,null, 0 ,int.MaxValue)];
reader.GetBytes(reader.GetOrdinal("FImage"), 0 ,Blob, 0 ,Blob.Length);

cmd.CommandType=CommandType.Text;
cmd.CommandText=@"
update
   SmthTable
set
   SmthField = ?
where
   SmthFieldWId = ?";
cmd.Parameters.Add("SmthField",OleDbType.Numeric);
cmd.Parameters.Add("SmthFieldWId",OleDbType.Numeric);

foreach(DataRow row in tmpDataTable.Rows)
{
	cmd.Parameters["SmthField"].Value=SmthValue;
	cmd.Parameters["SmthFieldWId"].Value=row["Id"];
	Result=cmd.ExecuteNonQuery();
}