当下面这段程序跑到Tmpdataset.Active:=True的时候,就报"不正常的定义了参数对象.提供了不一致或不完整的信息",这是为什么呢? S_Date:=formatdatetime('yyyy-mm-dd',DateTimePicker_Sdate.Date);
S_Time:=formatdatetime('hh:mm:ss',DateTimePicker_Stime.Time);
E_Date:=formatdatetime('yyyy-mm-dd',DateTimePicker_Edate.Date);
E_Time:=formatdatetime('hh:mm:ss',DateTimePicker_Etime.Time);
date_time:=' and (date_time between #'+S_Date+' '+S_Time+'# and #'+E_Date+' '+E_Time+'#)';
text1:='select barcode from cal_main where testid='''+testid+''''; tmpDataSet.CommandText :=text1+date_time;
tmpDataSet.Active :=true;
S_Time:=formatdatetime('hh:mm:ss',DateTimePicker_Stime.Time);
E_Date:=formatdatetime('yyyy-mm-dd',DateTimePicker_Edate.Date);
E_Time:=formatdatetime('hh:mm:ss',DateTimePicker_Etime.Time);
date_time:=' and (date_time between #'+S_Date+' '+S_Time+'# and #'+E_Date+' '+E_Time+'#)';
text1:='select barcode from cal_main where testid='''+testid+''''; tmpDataSet.CommandText :=text1+date_time;
tmpDataSet.Active :=true;
上面那段程序的问题在date_time这个变量上,如果我
将TmpDataSet.CommandText := text1+datetime改成
TempDataSet.CommandText := text1就问题了,但我不知道为
什么会这样??
上面那段程序的问题在date_time这个变量上,如果我
将TmpDataSet.CommandText := text1+datetime改成
TempDataSet.CommandText := text1就没问题了,但我不知道为
什么会这样??