General information
Category:
Database DAO/RDO/ODBC/ADO
>HI, J. Crescencio, I'm Using VFP 6.0
OK, assuming your connection parameters are correct and that strCode is a string and that intYear, intMonth are both integers, you can construct your SQL statement like so:
"Select * from mytable where code = '" & strcode & "' and year >=" & CStr(intYear) & " and month >=" & CStr(intMonth)
Note the single quotes before and after concatenating strcode.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only