Jump to content

Michael Longneck

  • Content Count

  • Joined

  • Last visited

Community Reputation

2 Neutral
  1. Michael Longneck

    Delphi 10.4, FireDac, StartTransaction causes ODBC error.

    That's happened because somewhere called TFDQuery.ExecSQL or TFDStoredProc.ExecProc but SQL stored proc return result set, which obviously not fetched but not discard. And now any attempt to StartTransaction (internally it's just turn off autocommit) will be failed with this "clear and detailed" error message. There's two options - call Query.Disconnect(True) or call Open instead ExecSQL\ExecProc.
  2. Just select @SysUserId as YourAutoIncFieldName