Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: how to control chr ' * ' in table
Thread ID: 396046 Message ID: 396060 # Views: 53 # Ratings: 3
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Wednesday, January 22, 2014 4:11:04 PM         
   


> > Dear Experts
> > i am facing a problem '*' in table on run time.
> > when i want to make some rate average then comes error like this '*', i mean when i multiply rate/qty if qty = 0 then its makes '*'
> > so how to control because it works stop and message appear that numeric data overflow.
> > please guide me how to solve it.
> > thanks
> > best regards
>
>
Yourresult = iif(qty>0,rate/qty,0)

>
> There's a fine line between helping and adding to the confusion.
>
> How to create sample data


:-)
Yourresult = iif(qty # 0,rate/qty,0)


-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

how to control chr ' * ' in table Posted by naveed ahmad @ 1/22/2014 2:23:29 PM
RE: how to control chr ' * ' in table Posted by Tore Bleken @ 1/22/2014 2:44:00 PM
RE: how to control chr ' * ' in table Posted by Borislav Borissov @ 1/22/2014 4:11:04 PM
RE: how to control chr ' * ' in table Posted by Tore Bleken @ 1/22/2014 4:29:16 PM
RE: how to control chr ' * ' in table Posted by Borislav Borissov @ 1/22/2014 5:10:53 PM
RE: how to control chr ' * ' in table Posted by Jun Tangunan @ 1/23/2014 5:32:21 AM
RE: how to control chr ' * ' in table Posted by naveed ahmad @ 1/23/2014 7:45:11 AM
RE: how to control chr ' * ' in table Posted by Tore Bleken @ 1/23/2014 7:52:11 AM
RE: how to control chr ' * ' in table Posted by naveed ahmad @ 1/23/2014 8:08:13 AM
RE: how to control chr ' * ' in table Posted by Tore Bleken @ 1/23/2014 8:14:53 AM
RE: how to control chr ' * ' in table Posted by naveed ahmad @ 1/23/2014 8:41:55 AM