Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How can I ... ?
Message
From
13/12/2000 16:01:20
 
 
To
13/12/2000 11:00:11
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:
00453074
Views:
24
>>>>>>>>>>>>>
I'm trying to create an ADO Recordset and when I want to assign it source property I put an SQL Statement like this:

"Select * from mytable where mytable.code = " & strcode & " and mytable.year & mytable.month >= intYear & intMonth"
>>>>>>>>>>>>>

Does it work if you say:
"Select * from mytable where mytable.code = " & strcode & _
"and mytable.year >= intYear and mytable.month >= intMonth"


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform