Profiler Object:Data Input - Revision history

Admin at 18:41, 6 March 2019

2019-03-06T18:41:14Z

← Older revision		Revision as of 18:41, 6 March 2019
Line 112:		Line 112:

	==GetColumnValue==		==GetColumnValue==
	This ~~unction~~ returns the contents of the specified column name. This comes handy to retrieve the parsed fields when using '''[[#AddDelimitedRecord\|AddDelimitedRecord]]'''.		This function returns the contents of the specified column name. This comes handy to retrieve the parsed fields when using '''[[#AddDelimitedRecord\|AddDelimitedRecord]]'''.

	Note that this function also works for the conventional SetColumn()/AddRecord () calling convention. However, the user should assume that the data provided by GetColumnValue() is only valid until AddRecord() is called. After that, a new row buffer is initialized, and the previous row’s data may not be valid.		Note that this function also works for the conventional SetColumn()/AddRecord () calling convention. However, the user should assume that the data provided by GetColumnValue() is only valid until AddRecord() is called. After that, a new row buffer is initialized, and the previous row’s data may not be valid.

Admin at 23:33, 14 May 2015

2015-05-14T23:33:48Z

← Older revision		Revision as of 23:33, 14 May 2015
Line 108:		Line 108:
	}}		}}

	After '''[[#AddDelimitedRecord]]''' has been called, the user can get the contents of each column with:		After '''[[#AddDelimitedRecord\|AddDelimitedRecord]]''' has been called, the user can get the contents of each column with:
	'''[[#GetColumnValue\|GetColumnValue(columnName)]]''' – which returns the contents of columnName.		'''[[#GetColumnValue\|GetColumnValue(columnName)]]''' – which returns the contents of columnName.

Admin at 23:32, 14 May 2015

2015-05-14T23:32:50Z

Show changes

Admin at 21:45, 23 February 2015

2015-02-23T21:45:51Z

@@ 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}}
@@ Line 104: / Line 27: @@
 |Syntax=profiler->SetColumn(columnNameStr, valueString);
 |C=mdProfilerSetColumn(profiler, ColumnName, ColumnValue);
-|.Net=profiler.SetColumnSize(ColumnName, ColumnValue);
+|.Net=profiler.SetColumn(ColumnName, ColumnValue);
 }}

Admin at 18:47, 2 February 2015

2015-02-02T18:47:08Z

← Older revision		Revision as of 18:47, 2 February 2015
Line 52:		Line 52:
	{\| 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: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 at 18:46, 2 February 2015

2015-02-02T18:46:25Z

← Older revision		Revision as of 18:46, 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]]

Admin at 18:42, 2 February 2015

2015-02-02T18:42:17Z

← Older revision		Revision as of 18:42, 2 February 2015
Line 110:		Line 110:
	This function sets the Null value of the specific column.		This function sets the Null value of the specific column.

	This function takes one ~~parameters~~.		This function takes one parameter.

	===Parameters===		===Parameters===

Admin: /* GetResults */

2015-01-07T22:11:13Z

GetResults

← Older revision		Revision as of 22:11, 7 January 2015
Line 135:		Line 135:

	==GetResults==		==GetResults==
	This function retrieves result codes for each column in the submitted record. This should be called after '''[[AddRecord]]'''.		This function retrieves result codes for each column in the submitted record. This should be called after '''[[#AddRecord\|AddRecord]]'''.

	This function accepts one Parameter.		This function accepts one Parameter.

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

2015-01-07T02:26:44Z

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 mw-collapsed" 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>

For each record to be profiled, call '''[[#SetColumn|SetColumn]]''' or '''[[#SetColumnNull|SetColumnNull]]''' for each column. After the values for all columns have been specified, call '''[[#AddRecord|AddRecord]]''' to submit the record for profiling. Note that if '''[[#SetColumn|SetColumn]]''' or '''[[#SetColumnNull|SetColumnNull]]''' are called more than once for the same column before '''[[#AddRecord|AddRecord]]''' is called, then the last function call's data will be used. Also, if neither '''[[#SetColumn|SetColumn]]''' nor '''[[#SetColumnNull|SetColumnNull]]''' are called before '''[[#AddRecord|AddRecord]]''', then the column is assumed to contain a NULL (i.e., the same as if you called '''[[#SetColumnNull|SetColumnNull]]''' for that column.)

==SetColumn==
This function sets the value of the specific column.

This function takes two parameters.

===Parameters===
{{Object Parameters2
|Name=ColumnName
|Data Type=String
|Description=Column Name to set the value.
|Name2=ColumnValue
|Data Type2=String
|Description2=Value for a specified column.
}}

{{ Object Syntax
|Syntax=profiler->SetColumn(columnNameStr, valueString);
|C=mdProfilerSetColumn(profiler, ColumnName, ColumnValue);
|.Net=profiler.SetColumnSize(ColumnName, ColumnValue);
}}

==SetColumnNull==
This function sets the Null value of the specific column.

This function takes one parameters.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to set the value to NULL.
}}

{{ Object Syntax
|Syntax=profiler->SetColumnNull(ColumnName);
|C=mdProfilerSetColumnNull(profiler, ColumnName);
|.Net=profiler.SetColumnNull(ColumnName);
}}

==AddRecord==
This function submits the record’s column values for profiling. No Parameters are required. After calling '''AddRecord''', the result for the current record will be available using '''[[#GetResults|GetResults]]'''.

{{ Object Syntax
|Syntax=profiler->AddRecrod();
|C=mdProfilerAddRecord(profiler);
|.Net=profiler.AddRecord();
}}

==GetResults==
This function retrieves result codes for each column in the submitted record. This should be called after '''[[AddRecord]]'''.

This function accepts one Parameter.

===Parameters===
{{Object Parameters
|Name=ColumnName
|Data Type=String
|Description=Column Name to get the result codes.
}}

===Return Value===
This returns a result codes specific to a column in string format.

{{ Object Syntax
|Syntax=profiler->GetResults(ColumnName);
|C=resultStr = mdProfilerGetResults(profiler, columnstr);
|.Net=resultStr = profiler.GetResults(columnstr);
}}

[[Category:Profiler Object]]