Jump to content

Michael Longneck

Members
 View Profile  See their activity

  • Content Count

    2

  • Joined

  • Last visited

Community Reputation

2 Neutral
  1. Michael Longneck

    Delphi 10.4, FireDac, StartTransaction causes ODBC error.

    Michael Longneck replied to Kyle Miller's topic in Databases

    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. Michael Longneck
    Just select @SysUserId as YourAutoIncFieldName
×