×

Loading...

Topic

This topic has been archived. It cannot be replied.
  • 工作学习 / IT技术讨论 / I can insert client data into db, but I can not query the recordId immidiately.
    I can insert client data into db, but I can not query the record Id immidiately. I need the primarykey id after the insert . but I can not get the correct resultSet. I can get the correct query in another query, but just after the insert sql command, the select query does not work.
    • 没有提交吧? For Oracle just running the command: SQL> Commit; Query Again!
    • If you are using SQL Server, the @@IDENTITYID is what you want