Hi all friends,
i have a code which works in winxp english version, but in winxp spanish
version its gives an error TYPE MISMATCH EXPRESSION
Any advice?????
here is a code.
Query32.Active :=true;
Query32.Close;
Query32.SQL.Clear;
Query32.SQL.Add('select * ');
Query32.SQL.Add('from ven.DB');
Query32.SQL.Add('Where Fchv >=:Date1');
Query32.SQL.Add('AND Fchv <=:Date2');
Query32.ParamByName('Date1').AsDate :=DateTimePicker5.Date;
Query32.ParamByName('Date2').AsDate :=DateTimePicker6.Date;
Query32.SQL.Add('AND Sc = '''+ edit25.text +'''');
Query32.SQL.Add('Order By Fchv' );
Query32.Open;
Query40.Active :=true;
Query40.Close;
Query40.SQL.Clear;
Query40.SQL.Add('select SUM(Rm)');
Query40.SQL.Add('from ven.DB');
Query40.SQL.Add('Where Fchv >=:Date1');
Query40.SQL.Add('AND Fchv <=:Date2');
Query40.ParamByName('Date1').AsDate :=DateTimePicker5.Date;
Query40.ParamByName('Date2').AsDate :=DateTimePicker6.Date;
Query40.SQL.Add('AND Sc = ''' + edit25.text +'''' );
Query40.Open;
qrmdform8.QuickRep1.Preview;
and the second inunder different button
Query32.Close;
Query32.SQL.Clear;
Query32.SQL.Add('select * ');
Query32.SQL.Add('from Ven.DB' );
Query32.SQL.Add('Order By Fchv');
Query32.Open;
Query40.Close;
Query40.SQL.Clear;
Query40.SQL.Add('select SUM(Rm)');
Query40.SQL.Add('from Ven.DB' );
Query40.Open;
QRMDForm10.QuickRep1.Preview;
Thanks a lot
---------------------------------
Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+
countries) for 2ยข/min or less.
[Non-text portions of this message have been removed]
-----------------------------------------------------
Home page: http://groups.yahoo.com/group/delphi-en/
To unsubscribe: [EMAIL PROTECTED]
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/delphi-en/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
