Login
Templates, Tools and Utilities
for Clarion Developers
Templates, Tools and Utilities
|
||
|
|
|
Add a comment to an Icetips ArticlePlease 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!
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 November 21, 2024, 7:31 am This article has been viewed 35265 times. Google search has resulted in 26 hits on this article since January 25, 2004.
|
|