Radicore Forum: How To » Transaction Pattern Advice

Home » RADICORE » How To » Transaction Pattern Advice

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Transaction Pattern Advice [message #1674]

Thu, 18 September 2008 11:08

gpatti
Messages: 283
Registered: August 2008

Senior Member

Would appreciate some guidance on the most suitable transaction pattern for some functionality:

I have a one -> many table relationship where the many table is controlled by start and end dates (so only one effective row per parent row at any given time).

I want to build a transaction that displays all the rows similar to a LINK1 transaction (where there would be exactly one line per parent row) but allows me to update a row on the many table (or even insert if one doesn't exist).

Can a LINK1 transaction be extended in this way?

Report message to a moderator

Re: Transaction Pattern Advice [message #1675 is a reply to message #1674]

Thu, 18 September 2008 13:22

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

The standard method of dealing with a one-to-many relationship is with a LIST2 pattern. The LINK1 pattern is for one-to-many-to-one (sometimes known as many-to-many) relationships.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Change the number of rows a list transaction displays
Next Topic:	PDF - Sorting output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Aug 21 15:20:10 EDT 2025

Total time taken to generate the page: 0.02782 seconds