` One-to-one relationship (Marius Roeksund ) - Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Icetips Article

Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

Par2: One-to-one relationship
1997-12-05 -- Marius Roeksund
 
Defining a MANY:1 relationship, with keys defined as UNIQUE will do this for you, if you just embed this short little code into the FORM. In the FILESCHEMATIC, you should add the related file to your "primary file", like this: UPDATE RECORD ON DISK +Primary file -----Related file This will lookup the related record for you, and you may add fields from that record on the form. When you exit, you must store the related record yourself.... In the embed "END OF PROCEDURE, BEFORE CLOSING FILES" you should add this code: if LocalRequest=RequestCompleted ! If OK is pressed... PUT(related file) ! Update related file End


Today is April 28, 2024, 6:48 am
This article has been viewed 35110 times.



Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password: