Strategies in Master/Detail relationships
lazarus / 16-Databases

----------------------------------------------------------------------
janasoft · 2014-01-10 11:40

Hello
I'm an (old) newbie programmer and I'm looking for the best practices
to establish master/detail relationships. I've searching in the
Lazarus forum and in many other places and I've found only isolated
opinions but no code examples. What I'm looking for is information
about thinks like:
- how to apply primary keys,
- how to transmit the PK from Master to Detail records,
- what's the best strategy to save records,
- what transaction level is the best,
and so on...

I would like to explore all possibilities: native Lazarus ant third
party component.

I've written a document where I've tried to resume my impressions and
conclusions. It's only a draft that I wish to improve with your
opinions and perhaps, if is interesting for all, publish it in the
wiki.

The document is written in spanish and translated by Google (¡Sorry!)

Best Regards

----------------------------------------------------------------------
BigChimp · 2014-01-10 11:53

FYI, please find some info on
http://wiki.lazarus.freepascal.org/MasterDetail

----------------------------------------------------------------------
janasoft · 2014-01-10 13:44

Quote from: BigChimp on January 10, 2014, 12:53:14 pmFYI, please find
some info on
http://wiki.lazarus.freepascal.org/MasterDetail
Thanks for the info. I have read that, and all the documents in the
wiki, related with DB and TSQLQuery (and many others related to other
aspects of Lazarus and of DataBases in general).

I know how to config a Master/detail relation. I know how to work with
parameters in a TSQLQuery. I know,less or than, to build a table
structure in a DB. Even I can make and aplication that make what I
want

So, what I would like to get from the forum is sahre several visions
of how to implement the CRUD processing in Lazarus, because I think
that mine, sure, it´s not the best.

Best Regards