Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select...into cursor used in grid
Message
De
27/03/1998 20:17:56
 
 
À
27/03/1998 17:14:19
Swen Nielsen
Squire Sanders & Dempsey
Cleveland, Ohio, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00087832
Message ID:
00087861
Vues:
32
>I tried it with and without an 'AS'. The ehading is 'EXP1' or similar.

Never Never do this!! Unless You are surely not to use the 'exp1' again!!

e.g. Select item.itemkey, item.PackQuant, item.Length, item.width, item.height,;
item.length * item.width * item.height * item.packquant / 1000000 AS CartonSize;
from item where itemkey = ?Thisform.txtitemkey.value ;
into cursor tmpitem

grid1.controlsource = tmpitem

Reasons:
1) You need to make a meaningful word to user
2) You will got trouble when edit and save the select again, especially in View!

Anyway, You can treate the calculation field as Real Field to use but of cos
cannot write it!
no one will use coding to remember 'exp1' !!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform