sql where clause with varible in workflow designer

Permanently deleted user

June 11, 2011 05:23

I am having some problems getting my workflow designer to select the right features from my query.

If I hardwire the value in the query like this:

"LINLOCID = 'L1388533'

 

the query selects the correct features and my get geometry and set mapextent work fine.

 

But if I use the variable like this:

"LINLOCID like '" & linlocid &"%'"

I do not get the selection I was expecting and the setmapextent function errors out.

 

Jeff

 

0

• 

  Permanently deleted user

  June 11, 2011 06:50

  The correct string concatenation operator is '+'

  So this should work for you:

  "LINLOCID like '" + linlocid + "%'"

  The string is SQL, but the syntax to make the string is Visual Basic. Make sense?

  EDIT: forgot the wildcard

  0
• 

  Permanently deleted user

  June 13, 2011 23:26

  Yes - that works!!

  Thanx,

  Jeff

   

  0

Please sign in to leave a comment.