Forum Discussion

megha_gambhire's avatar
megha_gambhire
Contributor
14 years ago

How to compare Table values.

My Scenario is that I am entering a some values in Text box as Call Aliases.QBIS.ExpressionEditor.expPanel.ExpressionEditorForm.expressionEdit.TextBoxMaskBox.Keys("3.5") Actually I am multiplyi...
AlexeyK's avatar
AlexeyK
Icon for Alumni rankAlumni
14 years ago

Hi Megha,


Perhaps, you can use the following code:




MyNumber = 3.5 ' Variable that will store the value

Call Aliases.QBIS.ExpressionEditor.expPanel.ExpressionEditorForm.expressionEdit.TextBoxMaskBox.Keys( CStr(MyNumber) )


Then, you can use  MyNumber * 2, MyNumber * 3, etc. in comparison statements.


An alternative approach is to set the value and then read the text box contents to a variable:




Aliases.QBIS.ExpressionEditor.expPanel.ExpressionEditorForm.expressionEdit.TextBoxMaskBox.Keys("3.5")

MyNumber = CInt(Aliases.QBIS.ExpressionEditor.expPanel.ExpressionEditorForm.expressionEdit.TextBoxMaskBox.Text)


If you use keyword tests, you can perform the same actions with the Set Variable Value operation.