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

sl6gs_at_cc.usu.edu wrote:
: 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"

I'm still a Delphi newbie, but the 'drop table' and the 'create table' are two distinct sql statements, and as such I don't think we can expect them to work when tied to one sql handle. The error is referring to the end of the drop table statement. Received on Thu Sep 21 1995 - 00:00:00 CEST