在ADOQuery中如何实现动态查询?? 可否象Query中实现动态查询: query1.SQL.Add('select * from part_data where trim(order)=(:order)'); query1.Params[0].AsString :=trim(q_order.Text);
adodm.ADOQuery2.Close; adodm.ADOQuery2.SQL.Clear; adodm.adoquery2.SQL.Add('select * from tb_cs where 日期 between >=:date1 and <=:date2'); adodm.adoquery2.Parameters.CreateParameter('date1',fdatetime,pdInput,10,0); adodm.adoquery2.Parameters.CreateParameter('date2',fdatetime,pdInput,10,0); adodm.ADOQuery2.Parameters.ParamByName('date1').Value :=StrToDateTime(edit35.Text); adodm.ADOQuery2.Parameters.ParamByName('date2').Value :=StrToDateTime(edit36.Text); adodm.ADOQuery2.Open
----------------------------------------------
ftUnknown Unknown or undetermined ftString Character or string field ftSmallint 16-bit integer field ftInteger 32-bit integer field ftWord 16-bit unsigned integer field ftBoolean Boolean field ftFloat Floating-point numeric field ftCurrency Money field ftBCD Binary-Coded Decimal field that can be converted to Currency type without a loss of precision. ftDate Date field ftTime Time field ftDateTime Date and time field ftBytes Fixed number of bytes (binary storage)
ftVarBytes Variable number of bytes (binary storage) ftAutoInc Auto-incrementing 32-bit integer counter field ftBlob Binary Large OBject field ftMemo Text memo field ftGraphic Bitmap field ftFmtMemo Formatted text memo field ftParadoxOle Paradox OLE field ftDBaseOle dBASE OLE field ftTypedBinary Typed binary field ftCursor Output cursor from an Oracle stored procedure (TParam only) ftFixedChar Fixed character field ftWideString Wide string field ftLargeint Large integer field
ftADT Abstract Data Type field ftArray Array field ftReference REF field ftDataSet DataSet field ftOraBlob BLOB fields in Oracle 8 tables ftOraClob CLOB fields in Oracle 8 tables ftVariant Data of unknown or undetermined type ftInterface References to interfaces (IUnknown) ftIDispatch References to IDispatch interfaces ftGuid globally unique identifier (GUID) values ftTimeStamp Date and time field accessed through dbExpress ftFMTBcd Binary-Coded Decimal field that is too large for ftBCD.
----------------------------------------------
query1.SQL.Add('select * from part_data where trim(order)=(:order)'); query1.parameters.parambyname('order').value:=trim(q_order.text);
----------------------------------------------
实践是检验真理的唯一标准!
var month:string; begin month:=combobox3.text; adoquery3.SQL.Add('select DISTINCT A.cpsn_name AS 姓名,B.m5 AS 身份证号,A.ISD_MONTH AS 所得期间,from wa_sds A,wa_psn B WHERE A.ISD_MONTH=:combobox3.text and A.ISD_MONTH=:month'); end; 这怎么不对??
var I: Integer; Str: String; StrList: TStringList; begin StrList := TStringList.Create; try with adoquery3 do begin for I := 0 to FieldCount-1 do Str := Str + Fields[I].FieldName + #9; First; while not Eof do begin Str := '; for I := 0 to FieldCount-1 do Str := Str + Fields[I].AsString + #9; StrList.Add(Str); Next; end; StrList.SaveToFile('test.xls'); end; StrList.Free; except StrList.Free; end;