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! Messengers 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
<*> 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/
