SOS: DELPHI/ORACLE HELP!!!!!!!!!

From: <sl6gs_at_cc.usu.edu>
Date: 1995/09/18
Message-ID: <1995Sep18.161620.61560_at_cc.usu.edu>#1/1


Date: 18 Sep 95 14:23:18 MDT

  I try to create table using Tquery Sql.add as follow:

procedure TReportForm.Button1Click(Sender: TObject); begin
  with reportQ do
  begin
    try

     disableControls;
     close;
     reportQ.active := false;
     sql.clear;
     sql.add(' drop table report1');
     Sql.Add(' create table report1 as');
     Sql.Add('select lname, fname ');
     Sql.Add('from pt_demo');
     Sql.Add('where card_no < 10200');
      Sql.Add('where card_no < 10200');
     reportq.active := true;
     open;
    finally
      Enablecontrols;

    end;
  end;
end;

  but it didnot work, a error message says that" not properly ended" and " error creating cursor handler"

any suggestion and help?
Thanks
Wei JIang

NEWS> Received on Mon Sep 18 1995 - 00:00:00 CEST

Original text of this message