Syntax error in SQL SELECT INTO FROM from Delphi

Question

I am trying to insert a new record into my database using SQL, but it keeps telling me that I have a syntax error in the from clause.

I don't see the error.

Here is the code:

procedure TForm1.BitBtn7Click(Sender: TObject);
var
 sCategoryName :string;
begin
 sCategoryName := InputBox('Category Name', 'Please enter your category name that you would like to add','');
 with dmRecords do
  begin
   qryRecords.Active := False;
   qryRecords.SQL.Add('INSERT INTO [Category of Income]([Category Name])');
   qryRecords.SQL.Add('VALUES ' + '(' + QuotedStr(sCategoryName) + ')');
   qryRecords.ExecSQL;
   qryRecords.SQL.Add('SELECT * FROM [Category of Income] ORDER BY [Category ID]');
   qryRecords.Active := True;
  end; 
end;

As a sidenote, please stop using concatenated SQL statements, use parameters instead. You are vulnerable to SQL injection. — whosrdaddy
– whosrdaddy, Commented Oct 9, 2015 at 12:18

David Dubois · Accepted Answer · 2015-10-09 11:48:42Z

1

You haven't cleared the SQL from the previous statement. When you open the query, SQL has three lines of text.

Add qryRecords.SQL.Clear before adding the SELECT statement.

answered Oct 9, 2015 at 11:48

David Dubois

3,9423 gold badges21 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Syntax error in SQL SELECT INTO FROM from Delphi

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related