Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DR instead of DB
Message
From
26/08/2008 12:48:10
 
 
To
26/08/2008 12:42:41
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01341863
Message ID:
01341870
Views:
16
This message has been marked as a message which has helped to the initial question of the thread.
>>What exactly do you mean here?
>
>A word to the wise. :)
>
>In TRANSFORM we can format the data.
>
>@C Appends CR to positive Currency or Numeric values to indicate a credit.
>
>@X Appends DB to negative currency or numeric values to indicate a debit.
>
>I want DB to be DR which is standard for Debit at least in accounting books.
>How can i achieve this in VFP?

You can use strtrans().
?Strtran(Transform(-10,'@X'),'DB','DR')
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform