INSERT INTO "tblPaymentTypes"
("OriginalINIValue","Description","OrderInList","GLCreditAccount","GLDebitAccount","Active")
VALUES (4,'Credit Card',4,'','',1)

The above statement works fine in the DB Manager, but not through a Delphi EDBQuery
I receive error 700

I've searched the news groups. It looks formatted correctly.

  with (p_qryWorking) do
  begin
      if (Active) then
      begin
          Close;
      end;
      Sql.Clear;
      // add any tracing of SQL here
      SQL.Add(p_sSQL);
      try
        ExecSQL;
      except
      on E: EDatabaseError do
        // cannot drop table because does not exist or no permission
        if (pos('3701',E.Message) > 0) then
          // do nothing, this is okay
        else begin
          ShowMessage(E.ClassName+' error raised, with message : '+E.Message
                     + CRLF
                     + 'SQL statment:'
                     + CRLF
                     + p_sSQL
                     );
          // some other error
          Raise;
        end;
      end;
  end;  // with
  Result := True;
end;

Daniel,

Please see my response in the elevatedb.general newsgroup.

--
Tim Young
Elevate Software
www.elevatesoft.com