Hello I have a command in a data environment that excutes a SQL statement it
now looks like this:
SELECT ToyOrders.* FROM ToyOrders WHERE (`Order ID` = 1)
Now here is what I want to do I want to be able to pass a variable into this
instead of the number.
Public FindorderNumber as Integer
I would like to pass FindOrderNumber (Which is declared in the general
declarations section of the form)
into this SQL statement instead of having to hard code a particular number I
guess like so but this does not work
SELECT ToyOrders.* FROM ToyOrders WHERE (`Order ID` = FindOrderNumber)
Does anyone know how to do this? Thanks!