adoquery的参数问题
AnsiString code,name,v;
adoq-> SQL-> Clear();
adoq-> Prepared = false;
adoq-> SQL-> Add( "insert into t_temp(f_code,f_name,f_v) values(:code,:name,:v) ");
adoq-> Prepared = true;
adoq-> Parameters-> ParamByName( "code ")-> Value = code; //varchar null
adoq-> Parameters-> ParamByName( "name ")-> Value = name; //varchar null
adoq-> Parameters-> ParamByName( "v ")-> Value = v == " "?NULL:StrToInt(v); //int null
adoq-> ExecSQL();
我想f_v字段里当v的值为空时插入数据库的NULL值,执行后,f_v里却是0,
怎么才能插入后数据库的NULL??
[解决办法]
adoq-> Parameters-> ParamByName( "v ")-> Value = v == " "?Null():StrToInt(v);
[解决办法]
adoq-> SQL-> Add( "insert into t_temp(f_code,f_name) values(:code,:name) ");