Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: CJ Wiley
  Where is CJ Wiley?
 Hideaway
 Texas - United States
 CJ Wiley
 To: Bhushan Sahni
  Where is Bhushan Sahni?
 Jabalpur/Mumbai
 India
 Bhushan Sahni
 Tags
Subject: RE: Calculated field/cursor show asterisks
Thread ID: 209567 Message ID: 209581 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 29, 2008 5:50:21 PM         
   


> > There is a calculated field in a cursor (that I’ve created) it keeps coming out as a line of asterisks. What does this mean?
> >
> > Fields used in calculation are numeric.
> >
> > THANKS!
>
> Hi,
> it means that the value stored in it is exceeding the storage limit for Eg. if its width is 5 you are storing a value more than 99999. Also if an improper calculated value like infinity or something like that is stored then it shows the *******.
>
> Hope this will help
>
> Regards
> Bhushan Sahni
> Millenium Softwares
> bhushan_sahni@yahoo.com
>
> Visual Foxpro a dream house for developers





Thanks Bhushan Sahni. Do you know if there is away around this?

This is my calculation for cursor field Bnos:
ROUND((dcursor2.blife/dcursor2.didhod3),0)

BLIFE is -0.001
didhod3 is 0.005
Bnos is shown as all asterisks.

ENTIRE THREAD

Calculated field/cursor show asterisks Posted by CJ Wiley @ 12/29/2008 4:47:36 PM
RE: Calculated field/cursor show asterisks Posted by Bhushan Sahni @ 12/29/2008 4:51:57 PM
RE: Calculated field/cursor show asterisks Posted by CJ Wiley @ 12/29/2008 5:50:21 PM
RE: Calculated field/cursor show asterisks Posted by Yuri Rubinov @ 12/29/2008 7:51:09 PM
RE: Calculated field/cursor show asterisks Posted by CJ Wiley @ 12/29/2008 7:56:50 PM