none
Problem with data inserting after table refreshing RRS feed

  • Question

  • Dear All,

     I'm using Delphi XE and SQL Server 2005.

    - I added 82 rows (data) in SQL table. /Delphi code: SQLInsertQuery.ExecSQL();/  - COMMAND SUCCESSFUL

    - Table refreshed after inserting add 82'th row (data) /Delphi code: TbTable.Refresh;/ - COMMAND SUCCESSFUL

    - I added 83'th row (data) in SQL table. /Delphi code: SQLInsertQuery.ExecSQL();/ - COMMAND SUCCESSFUL

    - Table refreshed after inserting add 83'th row (data) /Delphi code: TbTable.Refresh;/ - COMMAND SUCCESSFUL

    - I added 84'th row (data) in SQL table. /Delphi code: SQLInsertQuery.ExecSQL();/ - COMMAND unsuccessful

    - application not responding.  Application often crashed after every adding 84'th data in the table.

     no problem (not crash) if i inserting few data of 84.

    But i need insert more data of 84. At present application crashed. It is problem.

    How do i repair application (Delphi code)?   

    Many Thanks

    Saturday, January 13, 2018 5:28 PM

All replies

  • By any chance is it problem with data in 84th row you tried to insert?

    Also keep in mind that SQL 2005 has been out of support for quite sometime now so it might be the best time for you to upgrade to a supported version.


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Saturday, January 13, 2018 6:40 PM
  • Good day MByamba,

    This forum is for SQL Server express issue and not for Delphi issue. YOu should ask the question in forums that focus in Delphi, where probably you will find more expert in using Delphi.

    The question is not relevant to this forum


    signature   Ronen Ariely
     [Personal Site]    [Blog]    [Facebook]    [Linkedin]

    Saturday, January 13, 2018 11:01 PM