Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Reports showing only......
Message
 
 
À
15/05/2008 12:18:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01316516
Message ID:
01317354
Vues:
13
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform