# Add new feature to SQL Server via MapSuite

**URL:** <https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600>\
**Category:** WinForms\
**Created:** [February 22, 2011, 10:10am UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600 "2011-02-22T10:10:44Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Allen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/a/bbce88/32.png) [@Allen](https://community.thinkgeo.com/u/Allen)\
**Post date:** [February 22, 2011, 10:10am UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/1 "2011-02-22T10:10:44Z")

</div>

Good&nbsp;morning,

I'm&nbsp;writing&nbsp;a&nbsp;little&nbsp;experimental&nbsp;code&nbsp;to&nbsp;use&nbsp;the&nbsp;EditOverlay&nbsp;and&nbsp;a&nbsp;road&nbsp;feature&nbsp;SQL&nbsp;Server&nbsp;table&nbsp;to&nbsp;split&nbsp;a&nbsp;road&nbsp;at&nbsp;the&nbsp;point&nbsp;where&nbsp;the&nbsp;user&nbsp;adds&nbsp;a&nbsp;new&nbsp;vertex.&nbsp;&nbsp;(I'm&nbsp;using&nbsp;LineOnALine&nbsp;to&nbsp;get&nbsp;two&nbsp;new&nbsp;LineShapes,&nbsp;but&nbsp;that&nbsp;might&nbsp;not&nbsp;be&nbsp;important&nbsp;right&nbsp;now.)&nbsp;&nbsp;In&nbsp;one&nbsp;transaction,&nbsp;I'm&nbsp;trying&nbsp;to&nbsp;delete&nbsp;the&nbsp;old&nbsp;feature&nbsp;(I'd&nbsp;really&nbsp;like&nbsp;to&nbsp;update&nbsp;it,&nbsp;but&nbsp;haven't&nbsp;quite&nbsp;gotten&nbsp;that&nbsp;far)&nbsp;and&nbsp;add&nbsp;the&nbsp;two&nbsp;new&nbsp;features&nbsp;(the&nbsp;old&nbsp;line&nbsp;split&nbsp;into&nbsp;two&nbsp;new&nbsp;features).&nbsp;&nbsp;&nbsp;When&nbsp;I&nbsp;do&nbsp;this:

&nbsp;

MsSql2008FeatureLayer&nbsp;layer&nbsp;=&nbsp;(MsSql2008FeatureLayer)winformsMap1.FindFeatureLayer("Highways");

...the&nbsp;feature&nbsp;I&nbsp;want&nbsp;to&nbsp;delete&nbsp;is&nbsp;being&nbsp;deleted,&nbsp;but&nbsp;the&nbsp;two&nbsp;new&nbsp;features&nbsp;are&nbsp;never&nbsp;added&nbsp;to&nbsp;the&nbsp;table.&nbsp;&nbsp;No&nbsp;errors,&nbsp;just&nbsp;no&nbsp;new&nbsp;records.&nbsp;&nbsp;I&nbsp;refresh&nbsp;the&nbsp;map&nbsp;and&nbsp;the&nbsp;original&nbsp;feature&nbsp;is&nbsp;gone&nbsp;but&nbsp;the&nbsp;two&nbsp;new&nbsp;ones&nbsp;are&nbsp;not.&nbsp;&nbsp;(If&nbsp;I&nbsp;do&nbsp;a&nbsp;COUNT(\*)&nbsp;query&nbsp;before&nbsp;and&nbsp;after,&nbsp;the&nbsp;number&nbsp;decreases&nbsp;by&nbsp;1&nbsp;due&nbsp;to&nbsp;the&nbsp;deleted&nbsp;record,&nbsp;but&nbsp;should&nbsp;be&nbsp;increasing&nbsp;by&nbsp;1&nbsp;because&nbsp;I&nbsp;deleted&nbsp;1&nbsp;row&nbsp;and&nbsp;added&nbsp;two.)&nbsp;&nbsp;&nbsp;I&nbsp;have&nbsp;never&nbsp;added&nbsp;features&nbsp;through&nbsp;MapSuite&nbsp;before;&nbsp;we've&nbsp;always&nbsp;done&nbsp;it&nbsp;in&nbsp;code&nbsp;right&nbsp;to&nbsp;SQL&nbsp;Server.&nbsp;&nbsp;Anyone&nbsp;have&nbsp;any&nbsp;thoughts&nbsp;on&nbsp;why&nbsp;my&nbsp;records&nbsp;aren't&nbsp;being&nbsp;added?&nbsp;&nbsp;I&nbsp;thought&nbsp;perhaps&nbsp;a&nbsp;GID&nbsp;issue,&nbsp;but&nbsp;SQL&nbsp;Server&nbsp;will&nbsp;generate&nbsp;that,&nbsp;and&nbsp;then&nbsp;I&nbsp;thought&nbsp;perhaps&nbsp;an&nbsp;SRID&nbsp;issue&nbsp;I'd&nbsp;think&nbsp;the&nbsp;record&nbsp;would&nbsp;still&nbsp;be&nbsp;added&nbsp;to&nbsp;the&nbsp;table.

Thanks,

Allen

layer.FeatureSource.Open();

layer.FeatureSource.BeginTransaction();

layer.FeatureSource.DeleteFeature(args.AffectedVertexFeature.Id);

layer.FeatureSource.AddFeature(newFeature1);

layer.FeatureSource.AddFeature(newFeature2);

layer.FeatureSource.CommitTransaction();

layer.FeatureSource.Close();

---

<div class="post-metadata">

**Author:** ![ThinkGeo](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/thinkgeo/32/25029_2.png) [@ThinkGeo](https://community.thinkgeo.com/u/ThinkGeo)\
**Post date:** [February 23, 2011, 3:42am UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/2 "2011-02-23T03:42:31Z")

</div>

Allen,&nbsp;  
  
  
  
Thanks&nbsp;for&nbsp;your&nbsp;post,&nbsp;I&nbsp;have&nbsp;tested&nbsp;the&nbsp;delete&nbsp;and&nbsp;added&nbsp;features&nbsp;functions&nbsp;for&nbsp;MsSql2008FeatureLayer,&nbsp;they&nbsp;both&nbsp;work&nbsp;fine,&nbsp;so&nbsp;please&nbsp;test&nbsp;your&nbsp;application&nbsp;according&nbsp;to&nbsp;my&nbsp;steps&nbsp;again:&nbsp;  
  
  
  
1,&nbsp;Comment&nbsp;the&nbsp;delete&nbsp;feature&nbsp;code,&nbsp;just&nbsp;run&nbsp;the&nbsp;add&nbsp;features&nbsp;code,&nbsp;  
  
  
  
2,&nbsp;If&nbsp;the&nbsp;features&nbsp;cannot&nbsp;be&nbsp;added&nbsp;to&nbsp;your&nbsp;table&nbsp;correctly,&nbsp;so&nbsp;we&nbsp;can&nbsp;determine&nbsp;the&nbsp;problem&nbsp;is&nbsp;not&nbsp;from&nbsp;the&nbsp;delete&nbsp;function&nbsp;before&nbsp;you&nbsp;add&nbsp;the&nbsp;features.&nbsp;  
  
  
  
So&nbsp;please&nbsp;send&nbsp;the&nbsp;feature&nbsp;structures&nbsp;what&nbsp;you&nbsp;try&nbsp;to&nbsp;add&nbsp;to&nbsp;us,&nbsp;we&nbsp;guessed&nbsp;the&nbsp;problem&nbsp;is&nbsp;from&nbsp;the&nbsp;features,&nbsp;they&nbsp;are&nbsp;not&nbsp;the&nbsp;correct&nbsp;feature,&nbsp;  
  
  
  
Thanks,&nbsp;  
  
  
  
Scott,

---

<div class="post-metadata">

**Author:** ![Allen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/a/bbce88/32.png) [@Allen](https://community.thinkgeo.com/u/Allen)\
**Post date:** [February 23, 2011, 6:45am UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/3 "2011-02-23T06:45:01Z")

</div>

Good&nbsp;morning&nbsp;Scott,&nbsp;  
&nbsp;&nbsp;  
&nbsp;I&nbsp;will&nbsp;try&nbsp;removing&nbsp;the&nbsp;Delete&nbsp;and&nbsp;report&nbsp;back&nbsp;as&nbsp;soon&nbsp;as&nbsp;I&nbsp;get&nbsp;a&nbsp;few&nbsp;minutes.&nbsp;&nbsp;I’m&nbsp;wondering&nbsp;myself&nbsp;if&nbsp;it’s&nbsp;the&nbsp;attributes.&nbsp;&nbsp;I&nbsp;have&nbsp;checked&nbsp;the&nbsp;SQL&nbsp;Server&nbsp;error&nbsp;log&nbsp;and&nbsp;don’t&nbsp;see&nbsp;anything&nbsp;there,&nbsp;so&nbsp;I’m&nbsp;guessing&nbsp;the&nbsp;Adds&nbsp;are&nbsp;not&nbsp;getting&nbsp;that&nbsp;far.&nbsp;&nbsp;The&nbsp;SQL&nbsp;table&nbsp;has&nbsp;four&nbsp;float&nbsp;columns.&nbsp;&nbsp;I&nbsp;am&nbsp;simply&nbsp;pulling&nbsp;the&nbsp;column&nbsp;names&nbsp;and&nbsp;values&nbsp;out&nbsp;of&nbsp;the&nbsp;existing&nbsp;feature&nbsp;and&nbsp;adding&nbsp;them&nbsp;to&nbsp;the&nbsp;new&nbsp;features,&nbsp;and&nbsp;of&nbsp;course&nbsp;since&nbsp;Feature.ColumnValues&nbsp;&nbsp;is&nbsp;&nbsp;a&nbsp;Dictionary\<string,&nbsp;string\>&nbsp;so&nbsp;I&nbsp;wonder&nbsp;if&nbsp;something&nbsp;is&nbsp;going&nbsp;wrong&nbsp;there&nbsp;with&nbsp;the&nbsp;float&nbsp;numeric&nbsp;values.&nbsp;&nbsp;I&nbsp;think&nbsp;I&nbsp;have&nbsp;a&nbsp;similar&nbsp;layer&nbsp;that&nbsp;does&nbsp;not&nbsp;have&nbsp;any&nbsp;float&nbsp;columns&nbsp;I&nbsp;can&nbsp;check&nbsp;this&nbsp;on.&nbsp;&nbsp;That&nbsp;might&nbsp;help&nbsp;isolate&nbsp;things.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Thanks,&nbsp;  
&nbsp;Allen&nbsp;  
&nbsp;&nbsp;

---

<div class="post-metadata">

**Author:** ![Allen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/a/bbce88/32.png) [@Allen](https://community.thinkgeo.com/u/Allen)\
**Post date:** [February 23, 2011, 3:58pm UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/4 "2011-02-23T15:58:01Z")

</div>

Scott,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Here’s&nbsp;an&nbsp;update.&nbsp;  
&nbsp;&nbsp;  
&nbsp;I&nbsp;have&nbsp;removed&nbsp;everything&nbsp;but&nbsp;a&nbsp;single&nbsp;AddFeature&nbsp;to&nbsp;the&nbsp;transaction.&nbsp;&nbsp;I&nbsp;switched&nbsp;to&nbsp;a&nbsp;table&nbsp;that&nbsp;has&nbsp;no&nbsp;float&nbsp;columns.&nbsp;&nbsp;This&nbsp;is&nbsp;a&nbsp;hydro&nbsp;line&nbsp;table&nbsp;with&nbsp;just&nbsp;four&nbsp;columns:&nbsp;  
&nbsp;&nbsp;  
&nbsp;GID&nbsp;(Primary&nbsp;key,&nbsp;int,&nbsp;not&nbsp;null)&nbsp;  
&nbsp;GEOM&nbsp;(Geometry,&nbsp;not&nbsp;null)&nbsp;  
&nbsp;NAME&nbsp;(Nvarchar(130),&nbsp;not&nbsp;null)&nbsp;  
&nbsp;MTFCC&nbsp;(nvarchar(10),&nbsp;not&nbsp;null)&nbsp;  
&nbsp;&nbsp;  
&nbsp;The&nbsp;record&nbsp;is&nbsp;still&nbsp;not&nbsp;being&nbsp;written&nbsp;to&nbsp;the&nbsp;table.&nbsp;&nbsp;The&nbsp;feature&nbsp;I’m&nbsp;trying&nbsp;to&nbsp;write&nbsp;contains&nbsp;only&nbsp;values&nbsp;for&nbsp;NAME&nbsp;and&nbsp;MTFCC.&nbsp;&nbsp;I&nbsp;presume&nbsp;MapSuite&nbsp;is&nbsp;dealing&nbsp;with&nbsp;the&nbsp;geometry&nbsp;since&nbsp;it’s&nbsp;getting&nbsp;a&nbsp;Feature,&nbsp;and&nbsp;that&nbsp;SQL&nbsp;Server&nbsp;will&nbsp;be&nbsp;creating&nbsp;a&nbsp;new&nbsp;GID,&nbsp;so&nbsp;the&nbsp;feature&nbsp;I’m&nbsp;trying&nbsp;to&nbsp;write&nbsp;has&nbsp;just&nbsp;two&nbsp;columns.&nbsp;&nbsp;Any&nbsp;more&nbsp;ideas?&nbsp;&nbsp;I’ll&nbsp;keep&nbsp;tinkering.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Allen

---

<div class="post-metadata">

**Author:** ![Allen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/a/bbce88/32.png) [@Allen](https://community.thinkgeo.com/u/Allen)\
**Post date:** [February 23, 2011, 4:41pm UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/5 "2011-02-23T16:41:09Z")

</div>

I&nbsp;may&nbsp;have&nbsp;figured&nbsp;this&nbsp;out.&nbsp;&nbsp;I&nbsp;discovered&nbsp;that&nbsp;CommitTransaction&nbsp;returns&nbsp;status&nbsp;information.&nbsp;&nbsp;The&nbsp;error&nbsp;message&nbsp;was&nbsp;something&nbsp;like&nbsp;"cannot&nbsp;convert&nbsp;“XXX-XXX-XXX-XXX”&nbsp;to&nbsp;int.&nbsp;&nbsp;The&nbsp;only&nbsp;int&nbsp;column&nbsp;in&nbsp;the&nbsp;table&nbsp;is&nbsp;the&nbsp;GID,&nbsp;so&nbsp;this&nbsp;was&nbsp;very&nbsp;strange.&nbsp;&nbsp;It&nbsp;turns&nbsp;out&nbsp;the&nbsp;tool&nbsp;that&nbsp;uploads&nbsp;the&nbsp;data&nbsp;to&nbsp;SQL&nbsp;Server&nbsp;does&nbsp;not&nbsp;make&nbsp;the&nbsp;GID&nbsp;field&nbsp;IDENTITY,&nbsp;and&nbsp;I&nbsp;presume&nbsp;under&nbsp;the&nbsp;covers&nbsp;MapSuite&nbsp;sees&nbsp;this&nbsp;and&nbsp;is&nbsp;trying&nbsp;to&nbsp;convert&nbsp;its&nbsp;own&nbsp;internal&nbsp;ID&nbsp;to&nbsp;the&nbsp;GID&nbsp;for&nbsp;the&nbsp;table.&nbsp;&nbsp;Once&nbsp;I&nbsp;can&nbsp;rebuild&nbsp;this&nbsp;table&nbsp;with&nbsp;IDENTITY&nbsp;on&nbsp;the&nbsp;GID,&nbsp;I’m&nbsp;guessing&nbsp;things&nbsp;will&nbsp;work.&nbsp;&nbsp;I’ll&nbsp;report&nbsp;back.

---

<div class="post-metadata">

**Author:** ![Allen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/a/bbce88/32.png) [@Allen](https://community.thinkgeo.com/u/Allen)\
**Post date:** [February 23, 2011, 5:14pm UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/6 "2011-02-23T17:14:04Z")

</div>

Yes,&nbsp;that&nbsp;was&nbsp;it.&nbsp;&nbsp;I&nbsp;rebuilt&nbsp;the&nbsp;table&nbsp;with&nbsp;GID&nbsp;as&nbsp;IDENTITY,&nbsp;and&nbsp;everything’s&nbsp;working&nbsp;as&nbsp;expected.&nbsp;&nbsp;The&nbsp;delete&nbsp;and&nbsp;two&nbsp;adds&nbsp;are&nbsp;all&nbsp;being&nbsp;processed&nbsp;in&nbsp;the&nbsp;same&nbsp;transaction.&nbsp;&nbsp;The&nbsp;only&nbsp;thing&nbsp;I&nbsp;had&nbsp;to&nbsp;do&nbsp;was&nbsp;to&nbsp;filter&nbsp;out&nbsp;the&nbsp;GID&nbsp;column&nbsp;when&nbsp;copying&nbsp;the&nbsp;attributes&nbsp;from&nbsp;the&nbsp;original&nbsp;to&nbsp;the&nbsp;two&nbsp;new&nbsp;features&nbsp;since&nbsp;it&nbsp;is&nbsp;now&nbsp;being&nbsp;incremented&nbsp;by&nbsp;SQL&nbsp;Server.&nbsp;&nbsp;Whew.

---

<div class="post-metadata">

**Author:** ![ThinkGeo](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/thinkgeo/32/25029_2.png) [@ThinkGeo](https://community.thinkgeo.com/u/ThinkGeo)\
**Post date:** [February 23, 2011, 8:42pm UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/7 "2011-02-23T20:42:05Z")

</div>

Allen,

I&nbsp;checked&nbsp;the&nbsp;core&nbsp;code&nbsp;for&nbsp;the&nbsp;MsSql2008FeatureLayer&nbsp;and&nbsp;we&nbsp;found&nbsp;out&nbsp;there&nbsp;is&nbsp;a&nbsp;simple&nbsp;way&nbsp;can&nbsp;help&nbsp;you&nbsp;add&nbsp;the&nbsp;features&nbsp;more&nbsp;easily,&nbsp;you&nbsp;don't&nbsp;need&nbsp;to&nbsp;filter&nbsp;out&nbsp;the&nbsp;GID&nbsp;column&nbsp;before&nbsp;you&nbsp;add&nbsp;new&nbsp;features,&nbsp;you&nbsp;just&nbsp;need&nbsp;to&nbsp;set&nbsp;the&nbsp;GID&nbsp;column&nbsp;value&nbsp;to&nbsp;the&nbsp;Id&nbsp;property&nbsp;value&nbsp;of&nbsp;the&nbsp;new&nbsp;feature&nbsp;and&nbsp;insert&nbsp;the&nbsp;new&nbsp;feature&nbsp;to&nbsp;your&nbsp;table&nbsp;if&nbsp;you&nbsp;don't&nbsp;want&nbsp;to&nbsp;use&nbsp;the&nbsp;GID&nbsp;as&nbsp;IDENTITY.&nbsp;  
  
&nbsp;

Here&nbsp;is&nbsp;the&nbsp;code&nbsp;can&nbsp;help&nbsp;you&nbsp;understand&nbsp;it&nbsp;better&nbsp;and&nbsp;you&nbsp;can&nbsp;use&nbsp;it&nbsp;in&nbsp;your&nbsp;sample&nbsp;application&nbsp;directly:

`int GID = 12345;            Feature feature = new Feature(multiPolygon.GetWellKnownBinary(), GID.ToString());            feature.ColumnValues.Add("GID", string.Empty);            feature.ColumnValues.Add("NAME", "Test");            feature.ColumnValues.Add("MTFCC", "A10");            sql2008Layer.FeatureSource.AddFeature(feature);`Thanks,

Scott,

---

<div class="post-metadata">

**Author:** ![Allen](https://community.thinkgeo.com/letter_avatar_proxy/v4/letter/a/bbce88/32.png) [@Allen](https://community.thinkgeo.com/u/Allen)\
**Post date:** [February 24, 2011, 6:52am UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/8 "2011-02-24T06:52:23Z")

</div>

Scott,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Last&nbsp;night&nbsp;I&nbsp;actually&nbsp;expected&nbsp;I&nbsp;could&nbsp;do&nbsp;something&nbsp;like&nbsp;this&nbsp;and,&nbsp;in&nbsp;fact,&nbsp;I&nbsp;hard-coded&nbsp;a&nbsp;GID&nbsp;of&nbsp;“500000”&nbsp;into&nbsp;the&nbsp;GID&nbsp;column&nbsp;of&nbsp;the&nbsp;new&nbsp;feature&nbsp;and&nbsp;it&nbsp;worked.&nbsp;&nbsp;Ultimately&nbsp;our&nbsp;data&nbsp;will&nbsp;be&nbsp;using&nbsp;SQL&nbsp;Server&nbsp;replication&nbsp;to&nbsp;keep&nbsp;customers&nbsp;updated,&nbsp;so&nbsp;I&nbsp;really&nbsp;want&nbsp;to&nbsp;let&nbsp;SQL&nbsp;Server&nbsp;go&nbsp;about&nbsp;the&nbsp;business&nbsp;of&nbsp;creating&nbsp;the&nbsp;GID&nbsp;because&nbsp;it’s&nbsp;so&nbsp;vital&nbsp;in&nbsp;replication.&nbsp;&nbsp;Filtering&nbsp;out&nbsp;the&nbsp;GID&nbsp;column&nbsp;from&nbsp;the&nbsp;original&nbsp;feature&nbsp;is&nbsp;only&nbsp;one&nbsp;line&nbsp;of&nbsp;code.&nbsp;  
&nbsp;&nbsp;  
&nbsp;Anyway,&nbsp;I&nbsp;showed&nbsp;the&nbsp;results&nbsp;to&nbsp;the&nbsp;boss&nbsp;and&nbsp;he&nbsp;was&nbsp;satisfied&nbsp;we&nbsp;could&nbsp;do&nbsp;this,&nbsp;so&nbsp;I&nbsp;think&nbsp;that’s&nbsp;the&nbsp;end&nbsp;of&nbsp;the&nbsp;experiment&nbsp;until&nbsp;we&nbsp;define&nbsp;more&nbsp;editing&nbsp;tools.&nbsp;&nbsp;&nbsp;  
&nbsp;&nbsp;  
&nbsp;Thanks&nbsp;for&nbsp;your&nbsp;assistance,&nbsp;  
&nbsp;Allen

---

<div class="post-metadata">

**Author:** ![ThinkGeo](https://community.thinkgeo.com/user_avatar/community.thinkgeo.com/thinkgeo/32/25029_2.png) [@ThinkGeo](https://community.thinkgeo.com/u/ThinkGeo)\
**Post date:** [February 24, 2011, 9:06pm UTC](https://community.thinkgeo.com/t/add-new-feature-to-sql-server-via-mapsuite/1600/9 "2011-02-24T21:06:41Z")

</div>

Allen,&nbsp;  
&nbsp;&nbsp;  
&nbsp;You&nbsp;are&nbsp;welcome,&nbsp;that’s&nbsp;great&nbsp;to&nbsp;hear&nbsp;you&nbsp;that&nbsp;your&nbsp;solution&nbsp;can&nbsp;work&nbsp;fine&nbsp;now,&nbsp;if&nbsp;you&nbsp;still&nbsp;have&nbsp;any&nbsp;other&nbsp;questions&nbsp;please&nbsp;let&nbsp;us&nbsp;know&nbsp;again,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Thanks,&nbsp;  
&nbsp;&nbsp;  
&nbsp;Scott,