Profiler Object:Column-Based Value SoundEx Table Iteration - Revision history

Admin at 16:24, 15 May 2015

2015-05-15T16:24:08Z

← Older revision		Revision as of 16:24, 15 May 2015
Line 12:		Line 12:

	==StartSoundExFrequency==		==StartSoundExFrequency==
	This function initiates the iterator.		This function initiates the iterator. It returns 1 to indicate if there are records to iterate through. Otherwise it returns 0.

	This function takes two parameters.		This function takes two parameters.
Line 27:		Line 27:

	{{Object Syntax		{{Object Syntax
	\|Syntax=profiler->StartSoundExFrequency(columnNameStr, Order);		\|Syntax=int = profiler->StartSoundExFrequency(columnNameStr, Order);
	\|C=mdProfilerStartSoundExFrequency(profiler,columnNameStr, Order);		\|C=int = mdProfilerStartSoundExFrequency(profiler,columnNameStr, Order);
	\|.Net=profiler.StartSoundExFrequency(columnNameStr, Order);		\|.Net=integer = profiler.StartSoundExFrequency(columnNameStr, Order);
	}}		}}

Admin at 22:19, 23 February 2015

2015-02-23T22:19:01Z

@@ Line 2: / Line 2: @@
 [[Profiler Object:Reference|&larr; Profiler Object Reference]]
-{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
+{{ProfilerObjectNav
-! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
+|IteratorsCollapse=
-|-
+}}
@@ Line 121: / Line 46: @@
 {{Object Syntax
 |Syntax=profiler->GetSoundExFrequencyValue(columnNameStr);
-|C=string = mdProfilerGetSoundExFrequencyValue(profiler,columnNameStr);
+|C=const char* = mdProfilerGetSoundExFrequencyValue(profiler,columnNameStr);
 |.Net=string = profiler.GetSoundExFrequencyValue(columnNameStr);
 }}
@@ Line 139: / Line 64: @@
 {{Object Syntax
 |Syntax=profiler->GetSoundExFrequencyExample(columnNameStr);
-|C=integer = mdProfilerGetSoundExFrequencyExample(profiler,columnNameStr);
+|C=const char* = mdProfilerGetSoundExFrequencyExample(profiler,columnNameStr);
-|.Net=integer = profiler.GetSoundExFrequencyExample(columnNameStr);
+|.Net=string = profiler.GetSoundExFrequencyExample(columnNameStr);
 }}

Admin at 18:54, 2 February 2015

2015-02-02T18:54:32Z

← Older revision		Revision as of 18:54, 2 February 2015
Line 27:		Line 27:
	{\| class="mw-collapsible mw-collapsed" style="width:100%;"		{\| class="mw-collapsible mw-collapsed" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|[[Profiler Object:Column-Based Statistics\|Column-Based Statistics]]		! style="color:black; text-align:left;"\|[[Profiler Object:Column-Based Statistics\|Column-Based Statistics]]
	\|-		\|-
	\|[[Profiler Object:Column-Based String Statistics\|Column-Based String Statistics]]		\|[[Profiler Object:Column-Based String Statistics\|Column-Based String Statistics]]
Line 52:		Line 52:
	{\| class="mw-collapsible" style="width:100%;"		{\| class="mw-collapsible" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|[[Profiler Object:Iterators\|Iterators]]		! style="color:black; text-align:left;"\|[[Profiler Object:Iterators\|Iterators]]
	\|-		\|-
	\|[[Profiler Object:Column-Based Value Frequency Table Iteration\|Column-Based Value Frequency Table Iteration]]		\|[[Profiler Object:Column-Based Value Frequency Table Iteration\|Column-Based Value Frequency Table Iteration]]
Line 73:		Line 73:
	{\| class="mw-collapsible mw-collapsed" style="width:100%;"		{\| class="mw-collapsible mw-collapsed" style="width:100%;"
	\|- align="left"		\|- align="left"
	! style="color:black;"\|[[Profiler Object:Result Codes\|Result Codes]]		! style="color:black; text-align:left;"\|[[Profiler Object:Result Codes\|Result Codes]]
	\|-		\|-
	\|[[Returned Result Codes:APIs#Profiler Object\|Returned Result Codes]]		\|[[Returned Result Codes:APIs#Profiler Object\|Returned Result Codes]]

Admin: Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..."

2015-01-10T01:06:56Z

Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..."

New page

[[Profiler Object:Reference|← Profiler Object Reference]]

{| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size:9pt; color:#0645ad; padding:8px 8px;"
! style="text-align:left; color:black; border-bottom:1px solid #aaaaaa;"|'''Profiler Object Interface Navigation'''
|-
| style="padding-right:220px;"|
|-
|[[Profiler Object:Initialization|Initialization]]
|-
|[[Profiler Object:Object Information|Object Information]]
|-
|[[Profiler Object:Enumeration Listing and Parsing|Enumeration Listing and Parsing]]
|-
|[[Profiler Object:Column Specification|Column Specification]]
|-
|[[Profiler Object:Initiate Profiling|Initiate Profiling]]
|-
|[[Profiler Object:Data Input|Data Input]]
|-
|[[Profiler Object:Profiling|Profiling]]
|-
|[[Profiler Object:Table-Based Statistics|Table-Based Statistics]]
|-
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[Profiler Object:Column-Based Statistics|Column-Based Statistics]]
|-
|[[Profiler Object:Column-Based String Statistics|Column-Based String Statistics]]
|-
|[[Profiler Object:Column-Based Numeric Statistics|Column-Based Numeric Statistics]]
|-
|[[Profiler Object:Column-Based Date/Time Statistics|Column-Based Date/Time Statistics]]
|-
|[[Profiler Object:Column-Based Name Statistics|Column-Based Name Statistics]]
|-
|[[Profiler Object:Column-Based State/Province Statistics|Column-Based State/Province Statistics]]
|-
|[[Profiler Object:Column-Based Zip/Postal Code Statistics|Column-Based Zip/Postal Code Statistics]]
|-
|[[Profiler Object:Column-Based Country Statistics|Column-Based Country Statistics]]
|-
|[[Profiler Object:Column-Based Email Statistics|Column-Based Email Statistics]]
|-
|[[Profiler Object:Column-Based Phone Statistics|Column-Based Phone Statistics]]
|-
|}
|-
|
{| class="mw-collapsible" style="width:100%;"
|- align="left"
! style="color:black;"|[[Profiler Object:Iterators|Iterators]]
|-
|[[Profiler Object:Column-Based Value Frequency Table Iteration|Column-Based Value Frequency Table Iteration]]
|-
|[[Profiler Object:Column-Based Value Length Frequency Table Iteration|Column-Based Value Length Frequency Table Iteration]]
|-
|[[Profiler Object:Column-Based Value Pattern Table Iteration|Column-Based Value Pattern Table Iteration]]
|-
|[[Profiler Object:Column-Based Value Date/Time Table Iteration|Column-Based Value Date/Time Table Iteration]]
|-
|[[Profiler Object:Column-Based Value SoundEx Table Iteration|Column-Based Value SoundEx Table Iteration]]
|-
|[[Profiler Object:Column-Based Word Table Iteration|Column-Based Word Table Iteration]]
|-
|[[Profiler Object:Column-Based Word Length Table Iteration|Column-Based Word Length Table Iteration]]
|-
|}
|-
|
{| class="mw-collapsible mw-collapsed" style="width:100%;"
|- align="left"
! style="color:black;"|[[Profiler Object:Result Codes|Result Codes]]
|-
|[[Returned Result Codes:APIs#Profiler Object|Returned Result Codes]]
|-
|[[Result Codes]]
|}
|}

<div class="toclimit-2">{{CustomTOC}}</div>

These functions allow you to step through each distinct SoundEx pattern for a specific column.

==StartSoundExFrequency==
This function initiates the iterator.

This function takes two parameters.

===Parameters===
{{Object Parameters2
|Name=ColumnName
|Data Type=String
|Description=Column Name to start the iterator.
|Name2=Order
|Data Type2=Order
|Description2=This specifies how to order. See [[Profiler Object:Iterators#Order Enumeration|Order Enumeration]] for details.
}}

{{Object Syntax
|Syntax=profiler->StartSoundExFrequency(columnNameStr, Order);
|C=mdProfilerStartSoundExFrequency(profiler,columnNameStr, Order);
|.Net=profiler.StartSoundExFrequency(columnNameStr, Order);
}}

==GetSoundExFrequencyValue==
This function returns a column's distinct SoundEx pattern.

This function takes one parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the column’s distinct SoundEx pattern.
}}

{{Object Syntax
|Syntax=profiler->GetSoundExFrequencyValue(columnNameStr);
|C=string = mdProfilerGetSoundExFrequencyValue(profiler,columnNameStr);
|.Net=string = profiler.GetSoundExFrequencyValue(columnNameStr);
}}

==GetSoundExFrequencyExample==
This function returns an example value represented by the pattern. This will always be the first value encountered while profiling.

This function takes one parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get an example value represented by the pattern.
}}

{{Object Syntax
|Syntax=profiler->GetSoundExFrequencyExample(columnNameStr);
|C=integer = mdProfilerGetSoundExFrequencyExample(profiler,columnNameStr);
|.Net=integer = profiler.GetSoundExFrequencyExample(columnNameStr);
}}

==GetSoundExFrequencyCount==
This function returns the number of times the patterns appears in the profiled data for this particular column.

This function takes one parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the number of times the pattern appears in the profiled data.
}}

{{Object Syntax
|Syntax=profiler->GetSoundExFrequencyCount(columnNameStr);
|C=integer = mdProfilerGetSoundExFrequencyCount(profiler,columnNameStr);
|.Net=integer = profiler.GetSoundExFrequencyCount(columnNameStr);
}}

==GetNextSoundExFrequency==
This function steps to the next distinct pattern. It returns 1 if there are more distinct patterns or 0 when there are no more patterns.

This function takes one parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the next distinct pattern.
}}

{{Object Syntax
|Syntax=profiler->GetNextSoundExFrequency(columnNameStr);
|C=integer = mdProfilerGetNextSoundExFrequency(profiler,columnNameStr);
|.Net=integer = profiler.GetNextSoundExFrequency(columnNameStr);
}}

[[Category:Profiler Object]]