String variables would take the form:
sql ="select partno, description from Inventory where partno = '" & part & "'"
where the single quote begins the string value, then the sql variable is stopped and the variable containing the value is appended, then the final single quote is appended to the sql variable.
For numeric variables just leave off the single quotes:
sql ="select partno, description from Inventory where partno = " & part
For Microsoft Access Date types replace the single quote with a # (hash) mark.
For substituting the values in RFgen prompts without declaring variables:
sql ="select partno, description from Inventory where partno = '%part'"
RFgen will search and replace the text %part and replace it with the value in that prompt's textbox. Again if it should be numeric just leave off the single quotes.
To reference a prompt by number instead of name (in case of a loop structure):
sql ="select partno, description from Inventory where partno = '%3'" |
Application Downloads
back
