I think you have an issue on the date parameter when you pass on the
spanish OS. Try to investigate on the date being pass when using
spanish OS.
Arsen Khachatryan wrote:
> 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]
>
>
[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/
