Returing Value for a Type 1 Shape Data Element

Started by OldSchool1948, August 08, 2019, 02:17:52 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

OldSchool1948

I have a database shape with a "DBVersionNum" shape data element.  It is a dropdown list.

Relevant ShapeSheet cell entries:

  • Type cell contains  "1")
  • Format cell contains  "SQL2014;SQL2016;SQL2017")
  • Value cell contains "INDEX(0,Prop.DBVersionNum.Format)"

I'm trying to return a Format value using vsoShape.Cells("Prop.DBVersionNum").Resultstr("")

Instead of getting the value showing in the Shape Data window, e.g.,SQL2017, I get "INDEX(0,Prop.DBVersionNum.Format)"

Any help would be appreciated.

wapperdude

Everything looks OK and a quick test verified that you ought to see the desired value.  I'm assuming you manually typed in the cell entries rather than copy / paste, as there are minor issues with each one.

Perhaps a simple upload would be beneficial.
Visio 2019 Pro

OldSchool1948

Sometimes you can't see the forest for the trees.  In my "MS Database Server" shape sheet, I removed the quotes from around "INDEX(0,Prop.DBVersionNum.Format)"

Problem solved.  How the quotes got there in the first place is another matter. :-\

Thanks for your response, I helped me figure out what I was doing wrong.

Yacine

Yacine