Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Add memo field to cursor
Message
De
11/02/2016 02:57:20
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
 
 
À
11/02/2016 02:38:50
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
Divers
Thread ID:
01631223
Message ID:
01631233
Vues:
50
Something like that?
SELECT;
" " as MatProblem,;
CAST("" AS M) AS Missing,;
Curx.Line,Curx.priority,Curx.Customer,;
Curx.CUT,Curx.Desc_Cut,Curx.STYLE,Curx.Desc_Style,Curx.DUEDATE,;
Curx.total,Curx.totstd,Curx.cutdate,;
00000.00 as timetictot,;
00000.00 as timetic,;
00000.00 as balance,;
00000.00 as diasf,;
0000000.00 as horasf,;
DATE() as fec,;
00 as horad;
FROM (;
  SELECT Cut.Line, priority, bname as Customer, cut.CUT, cut.description as Desc_Cut, style.STYLE,;
		style.description as Desc_Style, DUEDATE, cut.total, totstd,cutdate;
	FROM cut, cutdtl, style, customer;
	WHERE cut.custcode = customer.code;
	AND cut.cut = cutdtl.cut;
	AND cutdtl.style = style.style;
	AND duedate >= thisform.text1.Value AND duedate <= thisform.text2.Value;
	AND EMPTY(dtcompl);
	AND cut.total > thisform.text10.Value;
	&lcExtra1 &lcExtra2;
	DISTINCT) as curx;
	INTO CURSOR cur1 READWRITE;
	ORDER BY Priority, DueDate
>When you use Distinct, you have to add the memo field afterwards by using Alter Table.
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord

Weeks of programming can save you hours of planning.

Off

There is no place like [::1]
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform