Good Morning!
Try this:
ADOQuery1.SQL.Add('Where Prov = ' +
QuotedStr(edit11.text));// this field is text
ADOQuery1.SQL.Add('AND Para = ' +
QuotedStr(edit14.text));// this field is text
ADOQuery1.SQL.Add('AND Tp = ' +
QuotedStr(edit15.text));// this field is text
ADOQuery1.SQL.Add('AND Utm = ' + edit6.text);//
this field is number
ADOQuery1.SQL.Add('AND Precio <= '+ edit8.text);//
this field is number
AOQuery1.Open;
Just make sure that edit 6 & 8 have valid numbers.
HTH...Dan'l
--- Arsen Khachatryan <[EMAIL PROTECTED]> wrote:
> Hello who can help me with query.I have a multi
> search insid DB (its in ms access)
> but it gives a error and can't understand what to
> do
> the code
>
> ADOQuery1.Active :=true;
> ADOQuery1.Close;
> ADOQuery1.SQL.Clear;
> ADOQuery1.SQL.Add('select * ');
> ADOQuery1.SQL.Add('from lb' );
> ADOQuery1.SQL.Add('Where Prov ='''+ edit11.text
> +'''' );// this field is text
> ADOQuery1.SQL.Add('AND Para =''' + edit14.text +''''
> );// this field is text
> ADOQuery1.SQL.Add('AND Tp =''' + edit15.text + ''''
> );// this field is text
> ADOQuery1.SQL.Add('AND Utm = ''' + edit6.text + ''''
> );// this field is number
> ADOQuery1.SQL.Add('AND Precio <= ''' + edit8.text +
> '''' );// this field is number
> AOQuery1.Open;
>
> thank you
>
>
> ---------------------------------
> How low will we go? Check out Yahoo! Messenger�s
low
> PC-to-Phone call rates.
>
> [Non-text portions of this message have been
> removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> --------------------~-->
> Great things are happening at Yahoo! Groups. See
> the new email design.
>
http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/i7folB/TM
>
--------------------------------------------------------------------~->
>
>
>
-----------------------------------------------------
> Home page: http://groups.yahoo.com/group/delphi-en/
> To unsubscribe:
> [EMAIL PROTECTED]
> Yahoo! Groups Links
>
>
> [EMAIL PROTECTED]
>
>
>
>
>
____________________________________
Every day is a Great day, but
some days are GREATER than others!
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
------------------------ Yahoo! Groups Sponsor --------------------~-->
See what's inside the new Yahoo! Groups email.
http://us.click.yahoo.com/2pRQfA/bOaOAA/yQLSAA/i7folB/TM
--------------------------------------------------------------------~->
-----------------------------------------------------
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/
