CRUD Sample
lazarus / 16-Databases

----------------------------------------------------------------------
dquinter · 2017-08-11 21:11

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

----------------------------------------------------------------------
mangakissa · 2017-08-12 07:02

to try it yourself (with examples from internet) is more satisfying
then use someone else code.
Or hire an pro.

----------------------------------------------------------------------
Handoko · 2017-08-12 07:14

Lazarus default installation has database examples:
Lazarus main menu > Tools > Example Projects > type 'database' in the
filter editbox

----------------------------------------------------------------------
valdir.marcos · 2017-08-12 08:09

Quote from: dquinter on August 11, 2017, 11:11:51 pmDoes 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_AWorkedExampleOfUsingTheTI
OPF.shtml

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

----------------------------------------------------------------------
mangakissa · 2017-08-12 09:08

Are you sure he wants use ORM

----------------------------------------------------------------------
valdir.marcos · 2017-08-12 09:33

Quote from: dquinter on August 11, 2017, 11:11:51 pmDoes 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.
Quote from: mangakissa on August 12, 2017, 11:08:12 amAre 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 · 2017-08-13 23:56

Quote from: mangakissa on August 12, 2017, 11:08:12 amAre you sure he
wants use ORM

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

----------------------------------------------------------------------
dquinter · 2017-08-13 23:57

Quote from: Handoko on August 12, 2017, 09:14:56 amLazarus default
installation has database examples:
Lazarus main menu > Tools > Example Projects > type 'database' in the
filter editbox

Thanks

----------------------------------------------------------------------
dquinter · 2017-08-13 23:58

Quote from: valdir.marcos on August 12, 2017, 10:09:27 amQuote from:
dquinter on August 11, 2017, 11:11:51 pmDoes 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_AWorkedExampleOfUsingTheTI
OPF.shtml

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

Ok, I will check the links