Assign frxDBXQuery (dbxpress) Date Params not work
Hi,
I have report scripts like this.
With qryProcess Do {TfrxDBXQuery}
begin
Close;
SQL.Clear;
SQL.Text := 'CREATE TABLE dbtemp.spcbill AS ( '+
'SELECT DISTINCT bs.INVNO '+
'FROM billspecial bs INNER JOIN billhead bh ON (bs.INVNO = bh.BILLHEAD_INVNO AND (bs.fmodgroup = ''001'') AND DATE(bh.billhead_date) between :st and :ed) '+
')';
Params[0].DataType := ftDate; //Set Param Type to Date.
Params[1].DataType := ftDate;
Params[0].Value := dtStart.Date;
Params[1].Value := dtEnd.Date;
ExecSQL;
end;
It is ERROR: dbExpress driver does not support the TDBXDataTypes.UNKOWN data type Vendor error message.
So I think it is not dbExpress bugs, because when code in delphi is work.
Does Fast report scripts has reassign params value in private Datset when I write Params[0].DataType?
Please suggestion?, What should i do.
Regards,
CMX.
I have report scripts like this.
With qryProcess Do {TfrxDBXQuery}
begin
Close;
SQL.Clear;
SQL.Text := 'CREATE TABLE dbtemp.spcbill AS ( '+
'SELECT DISTINCT bs.INVNO '+
'FROM billspecial bs INNER JOIN billhead bh ON (bs.INVNO = bh.BILLHEAD_INVNO AND (bs.fmodgroup = ''001'') AND DATE(bh.billhead_date) between :st and :ed) '+
')';
Params[0].DataType := ftDate; //Set Param Type to Date.
Params[1].DataType := ftDate;
Params[0].Value := dtStart.Date;
Params[1].Value := dtEnd.Date;
ExecSQL;
end;
It is ERROR: dbExpress driver does not support the TDBXDataTypes.UNKOWN data type Vendor error message.
So I think it is not dbExpress bugs, because when code in delphi is work.
Does Fast report scripts has reassign params value in private Datset when I write Params[0].DataType?
Please suggestion?, What should i do.
Regards,
CMX.