Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select...into cursor used in grid
Message
From
27/03/1998 20:17:56
 
 
To
27/03/1998 17:14:19
Swen Nielsen
Squire Sanders & Dempsey
Cleveland, Ohio, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00087832
Message ID:
00087861
Views:
31
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform