Assign frxDBXQuery (dbxpress) Date Params not work

cymonxcymonx
edited 9:09AM in FastReport 4.0
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.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024