Can I put the 2 things together and execute without manually having to replace :FIRSTNAME WITH John, etc. I might have many of these parameters in other queries where it would be a pain to type out
Item 1 Given
SELECT * FROM Database1
WHERE FIRSTNAME = :FIRSTNAME
AND LASTNAME = :LASTNAME
Item 2 Given
FIRSTNAME="John", LASTNAME="SMITH"
Tried the following but didn't work.
FIRSTNAME := 'JOHN';LASTNAME := 'SMITH';
SELECT * FROM Database1
WHERE FIRSTNAME = :FIRSTNAME
AND LASTNAME = :LASTNAME
