Help:how to write such a SQL string?

From: wen (wenheping_at_21cn.com)
Date: 10/27/04 

Date: Wed, 27 Oct 2004 16:11:02 +0800

i use adoquery and i want write such a SQL string similar to:

'select * from mytable where field1='aaa' and field2='bbb' sort by field3'

but every time i failed and Delphi told me symtax error, how can i write it
correctly?

Thanks!

Relevant Pages

  • Re: Feature request
    ... That would be nice, working with the format, QuotedStr() each time you ... want to embed a parameter based SQL string in your code can be tiresome. ... Phil. ... > When writing sql strings in Delphi code, ...
    (borland.public.delphi.non-technical)
  • Delphi 7.1enterprise update have a bug about AdoQuery support int64 ???
    ... I have a bigint field in SQL SERVER,its values is 7410555248535192980 ... I get it used adoquery before I update delphi 7.1. ...
    (borland.public.delphi.database.ado)
  • a question about delphi 7.1 update (its delphi 7 update bug?)
    ... I have a bigint field in SQL SERVER,its values is 7410555248535192980 ... I get it used adoquery before I update delphi 7.1. ...
    (borland.public.delphi.database.ado)
  • adoquery.Recordset.pagesize
    ... can anybody tell me how to use in DELPHI, the PageSize, AbsolutePage, ... properties of the Recordset property of an ADOQuery? ... set dbConn = SErver.CreateObject ...
    (borland.public.delphi.database.ado)