Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I ... ?
Message
From
14/12/2000 20:34:11
 
 
To
14/12/2000 09:27:59
Melvin Sequera
M&H New World, C.A.
Fuenlabrada, Spain
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Miscellaneous
Thread ID:
00452855
Message ID:
00453720
Views:
28
>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
Map
View

Click here to load this message in the networking platform