Hey guys,
I use Visual Studio 2010 and I'm developing a web application to register SQL queries. The question is how to interpret the parameters.
For the parameter types I'm adding the following endings to the parameters:
_S for String
_I for Integer
_D for Date and Time
_M for Decimals
_L when it is Like
_G when using IN
For example, I registered the following query:
SELECT A.ID, A.STATEID, A.NAME, B.UF
FROM CITIES TO
INNER JOIN B ON STATES (B.ID = A.STATEID)
WHERE B.UF = :UF_S AND A.NAME LIKE :NAME_S
How can I make it so that when the user executes this query, the system displays a grid showing the parameters and their respective types for the user to type their respective values?
