Profiler Object:Column-Based Value SoundEx Table Iteration: Difference between revisions
Jump to navigation
Jump to search
Created page with " ← Profiler Object Reference {| class="mw-collapsible" cellspacing="2" style="background-color:#f9f9f9; border:1px solid #aaaaaa; font-size..." |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
[[Profiler Object:Reference|← Profiler Object Reference]] | [[Profiler Object:Reference|← Profiler Object Reference]] | ||
{ | {{ProfilerObjectNav | ||
|IteratorsCollapse= | |||
}} | |||
{ | |||
| | |||
| Line 87: | 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 102: | 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); | ||
}} | }} | ||
| Line 121: | Line 46: | ||
{{Object Syntax | {{Object Syntax | ||
|Syntax=profiler->GetSoundExFrequencyValue(columnNameStr); | |Syntax=profiler->GetSoundExFrequencyValue(columnNameStr); | ||
|C= | |C=const char* = mdProfilerGetSoundExFrequencyValue(profiler,columnNameStr); | ||
|.Net=string = profiler.GetSoundExFrequencyValue(columnNameStr); | |.Net=string = profiler.GetSoundExFrequencyValue(columnNameStr); | ||
}} | }} | ||
| Line 139: | Line 64: | ||
{{Object Syntax | {{Object Syntax | ||
|Syntax=profiler->GetSoundExFrequencyExample(columnNameStr); | |Syntax=profiler->GetSoundExFrequencyExample(columnNameStr); | ||
|C= | |C=const char* = mdProfilerGetSoundExFrequencyExample(profiler,columnNameStr); | ||
|.Net= | |.Net=string = profiler.GetSoundExFrequencyExample(columnNameStr); | ||
}} | }} | ||
Latest revision as of 16:24, 15 May 2015
These functions allow you to step through each distinct SoundEx pattern for a specific column.
StartSoundExFrequency
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.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to start the iterator. |
| Order | Order | This specifies how to order. See Order Enumeration for details. |
| Syntax | int = profiler->StartSoundExFrequency(columnNameStr, Order); |
|---|---|
| C | int = mdProfilerStartSoundExFrequency(profiler,columnNameStr, Order); |
| .Net | integer = profiler.StartSoundExFrequency(columnNameStr, Order); |
GetSoundExFrequencyValue
This function returns a column's distinct SoundEx pattern.
This function takes one parameter.
Parameters
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the column’s distinct SoundEx pattern. |
| Syntax | profiler->GetSoundExFrequencyValue(columnNameStr); |
|---|---|
| C | const char* = 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
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get an example value represented by the pattern. |
| Syntax | profiler->GetSoundExFrequencyExample(columnNameStr); |
|---|---|
| C | const char* = mdProfilerGetSoundExFrequencyExample(profiler,columnNameStr); |
| .Net | string = 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
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the number of times the pattern appears in the profiled data. |
| 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
| Name | Data Type | Description |
|---|---|---|
| ColumnName | String | Column Name to get the next distinct pattern. |
| Syntax | profiler->GetNextSoundExFrequency(columnNameStr); |
|---|---|
| C | integer = mdProfilerGetNextSoundExFrequency(profiler,columnNameStr); |
| .Net | integer = profiler.GetNextSoundExFrequency(columnNameStr); |