RE: [DUG]: SQL (again)

[Wade Auchterlonie]

I think the date thing has been beaten out on this thread, but a comment on the offering below.

 

It's very tempting to use the double quote to delimit string data since delphi uses the single quote as a string delimiter, and too many quotes look ugly, but it you check where the sql standard is going double quotes are reserved for other reasons.

 

Instead, do something like this (and it takes care of embedded quotes):

 

    SQL.Add('and S.Seperator=' + QuotedStr(sSP1));

 

btw, Seperator is spelt Separator

 

etc etc etc etc

Wade Auchterlonie
mailto:[EMAIL PROTECTED]

 

-----Original Message-----
On Behalf Of Nigel Tavendale

with Query do
  begin
    Screen.Cursor:=crHourglass;
    if Active then Close;
    SQL.Clear;
    SQL.Add('Select * from S,C where S.Vessel=C.Object ');

    SQL.Add(' and S.Seperator="'+sSP1+'" ');

    SQL.Add(' and C.MeasDate="'+FormatDateTime('mm/dd/yy',Date)+'"' );
    Open;

    Screen.Cursor:=crDefault;
  end;