` Comment on an Icetips Article
Icetips - Templates, Tools & Utilities for Clarion Developers

Templates, Tools and Utilities
for Clarion Developers

Add a comment to an Icetips Article

Please add your comments to this article. Please note that you must provide both a name and a valid email address in order for us to publish your comment. Comments are moderated and are not visible until they have been approved. Spam is never approved!

Your Name:  
Email:  
Header text/Subject:  

Please enter your comment in the box below:
Back to article list   Search Articles     Add Comment     Printer friendly     Direct link  

Par2: Ad Hoc Joins using the Edit button on the file tree
1998-12-01 -- Andrew Guidroz II
 
> How do you hand code a join? > For instance... I have a browse on a Sales file. I have an Inventory Item that does not have a relationship defined in the dictionary although I know that SAL:InventoryItemPointer references a INV:InventoryItemUniqueNumber. I create a browse on the Sales file as the primary. I insert the Inventory Item file there under the Sales file. I press EDIT and click on the Custom radio button. In that blank space I type: SAL:InventoryItemPointer = INV:InventoryItemPointer And away I go . If I happen to have a key defined, the View engine is smart enough to use it -- very fast. If I don't happen to have one, it will dynamically index it.

Today is May 6, 2024, 8:20 am
This article has been viewed 35110 times.


Back to article list   Search Articles   Add Comment   Printer friendly

Login

User Name:

Password:


Gold Subscription
Buy Now
Silver Subscription
Buy Now
Solo Subscription
Buy Now
Multiple Copy Pricing
Renew Subscription