CreateGeneric(String) Method

Creates a new ClarifyGeneric based on the specified table or view name

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Function CreateGeneric( _
   ByVal tableName As String _
) As ClarifyGeneric

public virtual ClarifyGeneric CreateGeneric( 
   string tableName
)

Parameters

tableName: The name of the table or view on which the new generic will be based.

Return Value

A new ClarifyGeneric based on the specified table or view name

Remarks

NOTE: Generics based on views cannot be updated, modified, or related to other generics, rows, or values.

Example

This example shows how to create a generic from the session (it assumes that the application is already initialized and that a session has been created in the variable 'session'), traverse to children generics and iterate over rows.

// Create a dataset
ClarifyDataSet dataSet = new ClarifyDataSet(session);

// Get all cases, activity logs, and contact.
ClarifyGeneric gCase = dataSet.CreateGeneric("case");

ClarifyGeneric gAct = gCase.Traverse("case_act2act_entry");

ClarifyGeneric gContact = gCase.Traverse("case_reporter2contact");
  
// Now query the data
gCase.Query();
  
// Display return data to the console. First the case, then all
// activity logs then the one contact for the case
foreach( ClarifyDataRow caseRow in gCase )
{
    Console.WriteLine("Case ID: {0}", caseRow["id_number"]);
    
    // Show each act entry
    foreach( ClarifyDataRow actRow in caseRow.RelatedRows(gAct) )
    {
        Console.WriteLine("  Activity: {0}", actRow["objid"]);
    }
    
    // Show each contact
    foreach( ClarifyDataRow conRow in caseRow.RelatedRows(gContact) )
    {
        Console.WriteLine("  Contact: {0} {1}", conRow["first_name"], conRow["last_name"]);
    }
}

Visual Basic

' Create a dataset
Dim dataSet As New ClarifyDataSet(session)

' Get all cases, activity logs, and contact.
Dim gCase As ClarifyGeneric = dataSet.CreateGeneric("case")

Dim gAct As ClarifyGeneric = gCase.Traverse("case_act2act_entry")

Dim gContact As ClarifyGeneric = gCase.Traverse("case_reporter2contact")
  
' Now query the data
gCase.Query()
  
' Display return data to the console. First the case, then all
' activity logs then the one contact for the case
For Each caseRow As ClarifyDataRow In gCase

    Console.WriteLine("Case ID: {0}", caseRow("id_number"))
    
    ' Show each act entry
    For Each actRow As ClarifyDataRow In caseRow.RelatedRows(gAct)
        Console.WriteLine("  Activity: {0}", actRow("objid"))
    Next
    
    ' Show each contact
    For Each conRow As ClarifyDataRow In caseRow.RelatedRows(gContact)
        Console.WriteLine("  Contact: {0} {1}", conRow("first_name"), conRow("last_name"))
    Next
    
Next

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

Reference

ClarifyDataSet Class
ClarifyDataSet Members
Overload List