how to use a variable in a where clause in a form

Permanently deleted user

November 02, 2012 03:56

I have two list boxes.  the first list box shows a list of data fields and the user picks one. then I want to use the selection made by the user in my where clause in the second list box.  How do I use a variable in the list box form so that I can take the field selected by the user and query it in the second list box?

 

 

0

• 

  Permanently deleted user

  November 02, 2012 04:15

  Hi Jeff

  have you seen this video http://support.geocortex.com/configuring-listbox-and-combobox-controls-in-forms ?

  However on a re-read of your question you want to dynamically change the where statement which you can do BEFORE the form is presented to the user using RuntimeModifications.

  So for what you want you will need to have two forms where the second form has RuntimeModifications applied  using

  Assign Activity:   form.Find(Of ComboBoxFormItem)("<FormItemID>").QueryWhereClause    =  strFromPrevForm & " = {0}"

  Make sense?

  Regards

  Ralph

  0
• 

  Permanently deleted user

  November 02, 2012 04:53

  So for what you want you will need to have two forms where the second form has RuntimeModifications applied using

  Assign Activity:  form.Find(Of ComboBoxFormItem)("<FormItemID>").QueryWhereClause  = strFromPrevForm & " = {0}"

   

  So do you mean two separate display form activities?

   

  or the two list  boxes in the same form?

   

  in the assign activity is this all one phrase?   form.Find(Of ComboBoxFormItem)("<FormItemID>").QueryWhereClause  = strFromPrevForm & " = {0}"

  or is it 2 different assign activites ,  I see two equal signs?

  by strFromPrevForm is that what I am calling var1 ?

  I tried this in the assign expression editor and it did not like it.  am i missing something here?

  please let me know?

  Jeff

   

   

   

   

   

   

  0

Please sign in to leave a comment.