DataItem with Two Fields

Permanently deleted user

5. März 2015 05:20

Have a dataitem list (variable type Geocortex.FormsClient.DataItem) in my workflow to feed an upcoming form. 

The field concatenation string below works just fine.

item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_number").tostring + "/" + item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_status").tostring

But this one doesn't.

item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_number").tostring + "/" + item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.interred_persons").tostring

I get an "Object reference not set to an instance of an object" error.

The only thing I can think of is that there's some sort of limitation on the length of characters that the dataItem can hold? The "interred_persons" field is a text string holding the name(s) of one of many interred people.

Any help would be appreciated.....

Walter

 

 

 

0

• 

  Permanently deleted user

  5. März 2015 22:40

  When our SQLServer cemetery view is created from the master database, in order to display on the map the names of more that one interred person, the programmer has added the following characters in the interred persons field.....

  chr(10) + chr(13) => Carriage return & Line Feed

  So when I enter the line below in an assign statement

  dataItem1.value = item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_number").tostring + "-" + item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.interred_persons ").tostring

  dataItem1.display = item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.site_number").tostring + "-" + item.Attributes("GIS_StoneOrchard.GEOCORTEX.%GIS_cemetery_sites.interred_persons ").tostring

  I get an "Object reference not set to an instance of an object" error

  Therefore, my question is: How can I replace these two characters into something that will allow this assignment statement to work?

  Walter

   

   

   

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.