Recent

Author Topic: Need Theory Advicee On DBGrid Editing  (Read 1981 times)

pixelink

  • Hero Member
  • *****
  • Posts: 1269
Need Theory Advicee On DBGrid Editing
« on: May 01, 2019, 07:57:37 pm »
I only need advice on what to do.... no code, just a weird behavior that I need to troubleshoot.

When a person edits in a DB grid cell, then clicks off onto another cell, the DB saves fine.

But, if they edit a cell and then click the "POST" button (green "check-mark") on DB Navigator my app crashes.

Has this happened to anybody else or do you think something else is wrong??

Any advice is welcomed.

Thanks
Can't Type - Forgetful - Had Stroke = Forgive this old man!
LAZ 4.2.0 •  VSSTUDIO(.Net) 2022 • Win11 • 32G RAM • Nvida RTX 4070 Ti Super

devEric69

  • Hero Member
  • *****
  • Posts: 650
Re: Need Theory Advicee On DBGrid Editing
« Reply #1 on: May 02, 2019, 07:02:54 pm »
Quote
When a person edits in a DB grid cell, then clicks off onto another cell, the DB saves fine.

The focus is given to a new cell which is in another column in the same row, or a new cell in another row?
use: Linux 64 bits (Ubuntu 20.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

pixelink

  • Hero Member
  • *****
  • Posts: 1269
Re: Need Theory Advicee On DBGrid Editing
« Reply #2 on: May 02, 2019, 08:00:53 pm »
Quote
When a person edits in a DB grid cell, then clicks off onto another cell, the DB saves fine.

The focus is given to a new cell which is in another column in the same row, or a new cell in another row?

I already knew that.
That doesn't address why my app may be crashing when someone does that.

Thanks
Can't Type - Forgetful - Had Stroke = Forgive this old man!
LAZ 4.2.0 •  VSSTUDIO(.Net) 2022 • Win11 • 32G RAM • Nvida RTX 4070 Ti Super

ASBzone

  • Hero Member
  • *****
  • Posts: 733
  • Automation leads to relaxation...
    • Free Console Utilities for Windows (and a few for Linux) from BrainWaveCC
Re: Need Theory Advicee On DBGrid Editing
« Reply #3 on: May 02, 2019, 10:26:05 pm »
Quote
When a person edits in a DB grid cell, then clicks off onto another cell, the DB saves fine.

The focus is given to a new cell which is in another column in the same row, or a new cell in another row?

I already knew that.
That doesn't address why my app may be crashing when someone does that.

Thanks

I think he was asking you a question:

Is it: a new cell which is in another column in the same row
OR: a new cell in another row
-ASB: https://www.BrainWaveCC.com/

Lazarus v4.3.0.0 (bcf314a670) / FreePascal v3.2.3-46-g77716a79dc (aka fixes)
(Windows 64-bit install w/Win32 and Linux on ARM and x64 cross-compilers via FpcUpDeluxe)

My Systems: Windows 10/11 Pro x64 (Current)

pixelink

  • Hero Member
  • *****
  • Posts: 1269
Re: Need Theory Advicee On DBGrid Editing
« Reply #4 on: May 02, 2019, 10:28:23 pm »
Quote
When a person edits in a DB grid cell, then clicks off onto another cell, the DB saves fine.

The focus is given to a new cell which is in another column in the same row, or a new cell in another row?

I already knew that.
That doesn't address why my app may be crashing when someone does that.

Thanks

I think he was asking you a question:

Is it: a new cell which is in another column in the same row
OR: a new cell in another row

Yep... you right.... my rain fog mistake

It stays in the same cell when error occurs. And the error doesn't always happen either , its weird.

Can't Type - Forgetful - Had Stroke = Forgive this old man!
LAZ 4.2.0 •  VSSTUDIO(.Net) 2022 • Win11 • 32G RAM • Nvida RTX 4070 Ti Super

pixelink

  • Hero Member
  • *****
  • Posts: 1269
Re: Need Theory Advicee On DBGrid Editing
« Reply #5 on: May 02, 2019, 10:33:36 pm »
Its's also hard to replicate the error. I can sit for five minutes and keep editing a cell, click the POST button but it works.

It's just happens once and a while.

I am trying to keep my an eye on a pattern to see if I can be more descriptive of the problem. But not enough info to go by yet.

Can't Type - Forgetful - Had Stroke = Forgive this old man!
LAZ 4.2.0 •  VSSTUDIO(.Net) 2022 • Win11 • 32G RAM • Nvida RTX 4070 Ti Super

pixelink

  • Hero Member
  • *****
  • Posts: 1269
Re: Need Theory Advicee On DBGrid Editing
« Reply #6 on: May 02, 2019, 10:35:54 pm »
Quote
When a person edits in a DB grid cell, then clicks off onto another cell, the DB saves fine.

The focus is given to a new cell which is in another column in the same row, or a new cell in another row?

I already knew that.
That doesn't address why my app may be crashing when someone does that.

Thanks

I think he was asking you a question:

Is it: a new cell which is in another column in the same row
OR: a new cell in another row

Sorry... didn't realize it was a question.

It stays in the same cell when error occurs. And the error doesn't always happen either , its weird.
Can't Type - Forgetful - Had Stroke = Forgive this old man!
LAZ 4.2.0 •  VSSTUDIO(.Net) 2022 • Win11 • 32G RAM • Nvida RTX 4070 Ti Super

devEric69

  • Hero Member
  • *****
  • Posts: 650
Re: Need Theory Advicee On DBGrid Editing
« Reply #7 on: May 07, 2019, 12:18:34 pm »
There is not enough information.
You should post your source code as clean as possible: simply your database with just a simple table, a TDatabase, a TTable, a TDataSource, and a TDBGrid and a TDBNavigator, and finally without code in events.

And we should know if it is a local development in an auto-commit way, or a transactional development, ...
« Last Edit: May 07, 2019, 12:24:26 pm by devEric69 »
use: Linux 64 bits (Ubuntu 20.04 LTS).
Lazarus version: 2.0.4 (svn revision: 62502M) compiled with fpc 3.0.4 - fpDebug \ Dwarf3.

 

TinyPortal © 2005-2018