Recent

Author Topic: CRUD Sample  (Read 8477 times)

dquinter

  • New member
  • *
  • Posts: 7
CRUD Sample
« on: August 11, 2017, 11:11:51 pm »
Hi all.

Does anyone have an example of a form with Create, Read, Update and Delete (CRUD) to a table?

But not only the basic examples, with a grid and a dbnavigator, but something a bit more complex, with field validation, error handling, a more elaborate look & feel.

Is it possible?

Thanks for all, and regards from CDMX  >:D

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: CRUD Sample
« Reply #1 on: August 12, 2017, 09:02:58 am »
to try it yourself (with examples from internet) is more satisfying then use someone else code.
Or hire an pro.
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

Handoko

  • Hero Member
  • *****
  • Posts: 5131
  • My goal: build my own game engine using Lazarus
Re: CRUD Sample
« Reply #2 on: August 12, 2017, 09:14:56 am »
Lazarus default installation has database examples:
Lazarus main menu > Tools > Example Projects > type 'database' in the filter editbox

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: CRUD Sample
« Reply #3 on: August 12, 2017, 10:09:27 am »
Does anyone have an example of a form with Create, Read, Update and Delete (CRUD) to a table?
But not only the basic examples, with a grid and a dbnavigator, but something a bit more complex, with field validation, error handling, a more elaborate look & feel.

Another way might be:
http://wiki.freepascal.org/tiOPF
http://tiopf.sourceforge.net/Doc/overview/
http://geldenhuys.co.uk/articles/
http://tiopf.sourceforge.net/

This is a complete real-world CRUD application example with "a more elaborate look & feel":
http://tiopf.sourceforge.net/Doc/Concepts/5_AWorkedExampleOfUsingTheTIOPF.shtml

tiOPF Model GUI Mediator / MVP - Part 1
Jarrod Hollingworth
https://www.youtube.com/watch?v=FBw_3gXxyeI

mangakissa

  • Hero Member
  • *****
  • Posts: 1131
Re: CRUD Sample
« Reply #4 on: August 12, 2017, 11:08:12 am »
Are you sure he wants use ORM
Lazarus 2.06 (64b) / FPC 3.0.4 / Windows 10
stucked on Delphi 10.3.1

valdir.marcos

  • Hero Member
  • *****
  • Posts: 1106
Re: CRUD Sample
« Reply #5 on: August 12, 2017, 11:33:49 am »
Does anyone have an example of a form with Create, Read, Update and Delete (CRUD) to a table?
But not only the basic examples, with a grid and a dbnavigator, but something a bit more complex, with field validation, error handling, a more elaborate look & feel.

Are you sure he wants use ORM?

No, but since he asked for something a bit more complex, I thought about a more OOP solution than just a simple RAD solution.
Besides, Graeme Geldenhuys' articles and tutorials are very detailed. Making them an excellent learning material for both beginners and advanced students.

dquinter

  • New member
  • *
  • Posts: 7
Re: CRUD Sample
« Reply #6 on: August 14, 2017, 01:56:51 am »
Are you sure he wants use ORM

I had not thought about that, but it might be a very good idea.  ::)

dquinter

  • New member
  • *
  • Posts: 7
Re: CRUD Sample
« Reply #7 on: August 14, 2017, 01:57:27 am »
Lazarus default installation has database examples:
Lazarus main menu > Tools > Example Projects > type 'database' in the filter editbox

Thanks

dquinter

  • New member
  • *
  • Posts: 7
Re: CRUD Sample
« Reply #8 on: August 14, 2017, 01:58:27 am »
Does anyone have an example of a form with Create, Read, Update and Delete (CRUD) to a table?
But not only the basic examples, with a grid and a dbnavigator, but something a bit more complex, with field validation, error handling, a more elaborate look & feel.

Another way might be:
http://wiki.freepascal.org/tiOPF
http://tiopf.sourceforge.net/Doc/overview/
http://geldenhuys.co.uk/articles/
http://tiopf.sourceforge.net/

This is a complete real-world CRUD application example with "a more elaborate look & feel":
http://tiopf.sourceforge.net/Doc/Concepts/5_AWorkedExampleOfUsingTheTIOPF.shtml

tiOPF Model GUI Mediator / MVP - Part 1
Jarrod Hollingworth
https://www.youtube.com/watch?v=FBw_3gXxyeI

Ok, I will check the links

 

TinyPortal © 2005-2018