数据库中数值型数据类型
使用C中的CHAR类型变量进行绑定,用于输入和输出。具体的有:TINYINT、SMALLINT、INT、BIGINT、FLOAT、DOUBLE和NUMERIC等。
示例:
c
char c1[]="123";
char c2[]="34";
char c3[]="777";
char c4[]="23.42";
char c5[]="3322.4564";
char c6[]="121212";
char c7[]="863977";
SQLBindParameter(hstmt, 1, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_TINYINT,10,0,c1,10,&cbLen1);
SQLBindParameter(hstmt, 2, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_SMALLINT,10,0,c2,10,&cbLen2);
SQLBindParameter(hstmt, 3, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_INTEGER,11,0,c3,11,&cbLen3);
SQLBindParameter(hstmt, 4, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_FLOAT,21,0,c4,21,&cbLen4);
SQLBindParameter(hstmt, 5, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_DOUBLE,21,0,c5,21,&cbLen5);
SQLBindParameter(hstmt, 6, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_BIGINT,21,0,c6,21,&cbLen6);
SQLBindParameter(hstmt, 7, SQL_PARAM_INPUT,SQL_C_CHAR,SQL_NUMERIC,21,0,c7,21,&cbLen7);