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.
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.
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.
Clear case of 8) - bad glasses. ;D
Yep :)