Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to typecase a numeric type
Message
From
20/07/1997 10:12:49
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
18/07/1997 23:07:39
Shihchau Tai
Apic Systems Pte Ltd
Singapore, Singapore
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00040343
Message ID:
00040803
Views:
39
Let@s make it clear :
Date Amount Flag
01/01/97 100000 Income
01/02/97 200000 Payment
01/03/97 200000 Income
01/04/97 5000 Payment
And I want crosstab like :

Date Income Payment
01/01/97 100000
01/02/97 200000
01/03/97 200000
01/04/97 5000
Without big numbers I get :
Date Income Payment
01/01/97 100000 0
01/02/97 *
01/03/97 200000 0
01/04/97 *
Ç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
Reply
Map
View

Click here to load this message in the networking platform