如果按下面这样一段程序,如何将当前时间放入到SQL的DateTime字段中ADOCommand1->CommandText = "Insert Into Test (Name,Birthday) values (:Name,:Value)
ADOCommand1->ParamCheck();
ADOCommand1->Parameters->ParamByName("Name")->Value = Edit1->Text;
ADOCommand1->Parameters->ParamByName("Birthday") ---????
ADOCommand1->ParamCheck();
ADOCommand1->Parameters->ParamByName("Name")->Value = Edit1->Text;
ADOCommand1->Parameters->ParamByName("Birthday") ---????
也是可以的!
strCommText = "Insert Into " + strTableName + "(sysid,";
if(bAllField)
strCommText = strCommText + strInsertField;// strCommText = strCommText + ") valus(:sysID, :RecordDatetime, ";
strCommText = strCommText + ") values(:sysID,";
if(bAllField)
strCommText = strCommText + strInsertValue;
strCommText = strCommText + ")"; InsertCommand->CommandText = strCommText;
InsertCommand->ParamCheck; InsertCommand->Parameters->ParamByName("sysID")->Value = count;
// InsertCommand->Parameters->ParamByName("RecordDatetime")->Value = "2003/5/14 16:22:22";//DateTimeToStr(Now());
......
程序注释掉的语句如执行要参生错误,报告不正常的参数定义
两种方法都一样
例:
insert into lk(dateD) values('2002-02-03')
这个是完全错误的
Delphi中字符串不能用双引号引起来。
'2002-02-03'
// strCommText = strCommText + ") valus(:sysID, :RecordDatetime, ";
strCommText = strCommText + ") values(:sysID, ";
values 写成了valus
还是要感谢大家