Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Day two with Active VFP
Message
From
09/11/2003 11:30:41
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
ActiveVFP
Title:
Day two with Active VFP
Miscellaneous
Thread ID:
00848074
Message ID:
00848074
Views:
60
I have a table with two fields. I want to use a SQl statement to extract memo fields based on a date field to a cursor. Here is the code that works in foxpro 8.0

Select Prepdata From showprep Where Day(Date()) = Day(prepdate) And Month(Date()) = Month(prepdate) INTO cursor tempprep

Prepdate is a date field
Prepdata is a memo field

Being a novice at ActiveVFP, I am stuck here. I cannot seem to get the code to run. Any suggestions will be welcome.

Grady
I ain't skeert of nuttin eh?
Yikes! What was that?
Next
Reply
Map
View

Click here to load this message in the networking platform