Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding quantity in free table
Message
From
15/12/2006 13:32:35
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
15/12/2006 13:28:13
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01178051
Message ID:
01178083
Views:
14
>Hi Cetin,
>
>Thank you so much for taking the time to revise my code and encouraging me to join UT...
>
>I took the first code that you created and my data is dead on. However, somehow my PerRej is rounding up to whole number; for example, instead of 1.58, it will show 2. Please advice.
>
>Thanks,
>Sam

Sam,
Ed's sql is more compact and does it one SQL. Check that one.

In cursor definition:
PerRej N(4,2),
change to:
b(2) or y.

If you use 2nd version or Ed's single SQL then VFP would take care of it for you.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform