Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Reports showing only......
Message
 
 
To
15/05/2008 12:18:21
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01316516
Message ID:
01317354
Views:
12
>So from MS example in the help file it looks like I am supposed to insert the line where strain=blueberry or ??? is after the from line but when I insert this line I get the error SQL column blueberry is not found. below is the working code I have so far
>
>
>SELECT strain, quantity, location2, userid, date, notes ;
>	FROM cuttings ;
         where strain = 'blueberry' ;
>	ORDER BY date ASC, strain ASC ;
>	INTO CURSOR cuttingsreport
>SELECT cuttingsreport
>REPORT FORM cuttings1.frx TO PRINTER  PROMPT  PREVIEW
>CLOSE DATABASES ALL
>
>
>As usual confused over something probably very simple I am sure.
>
>Any ideas.
>
>Thanks,
>
>Fred W.
SELECT strain, quantity, location2, userid, date, notes ;
	FROM cuttings ;
         WHERE strain = 'blueberry' ;
	ORDER BY date ASC, strain ASC ;
	INTO CURSOR cuttingsreport
SELECT cuttingsreport
REPORT FORM cuttings1.frx TO PRINTER  PROMPT  PREVIEW
CLOSE DATABASES ALL
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform