Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Icetips Article
Back to article list
Search Articles
Add Comment
Printer friendly
Direct link
Icetips Products: Icetips SQL: Parent-Child multicomponent key 2002-09-18 -- Andy Stapleton Newsgroups: softvelocity.products.c55ee
> C55ee - CCS templates
> DB2 db on AS400, access through ODBC
> I have a file with this structure :
>
> K1 - K2 - K3 - Loc - Quantity1 - Quantity2 - etc...
>
> The key is K1 - K2 - K3 - Loc
>
> When LOC = 0 : the quantities are the total of the records where LOC <> 0
> Om the browse, I have a parent file with only the records where LOC = 0
>
> On the second browse, the child, I want to show the records where LOC <> 0
>
> Obviously when a record is selected in the parent (total) I want to show the
> detail records in the child browse.
> I have used an alias to open the file twice
>
> in the CCS templates, I can do child synchronisation, but only on 1 ID
> field. In my case there are 3 fields : K1,K2 & K3.
>
> Any idea how this can be done ? I need a fast access as the file contains +-
> 100000 records.
Set the first connection in the Child Syncronization...
Go to the Source and search for that connection, you will find that it is a
string putting the 2 fields together, cut and paste it into the embed point
afterwards and add your other 2 fields..
--
Andy <
Today is April 27, 2024, 5:02 pm This article has been viewed 35099 times. Google search has resulted in 26 hits on this article since January 25, 2004.
|
|