Thanks Ramani and Rick for your great help.
Dear Ramani,
If you run "IF n # INT(n/1)" return false. But next statement "LEN(SUBSTR(TRANSFORM(n),AT(".",transform(n))+1))" definately works for me.
Thanks with warm regards
Shah AV
I have some numbers. How to figure out each number has how many decimal points?. Suppose user has entered following numbers:
100.01
100.001
100.0001
Thanks in advance.
Shah AV
Dears
I am trying to print Invoice# on top of page. It is located at .5" scale of page header. I am using VFP 6.0. Invoice# does not display on screen or print on paper. I am using pre-printed stationery and dot matrix printer. I have already set top margin 0. Any idea?
Thanks in Advance.
I have a query which has more 100 records. I want to display only first 10 records. For example:
Select Customer.Company_Name, Max(Orders.Order_Date) AS dMostRecent From Customer ;
Left Join Orders ;
On Customer.Customer_ID = Orders.Customer_ID ;
Group By 1 ;
Into Cursor MostRecentOrder
Any...
Dear Gurvinder,
Thanks for reply. I did just created same report again in VFP 8.0 and it works fine with both versions (6&8). But, still I am not happy with solution. We need to find out exactly what it causes the problem.
Regards
Atul
I have a text box which shows price/unit. I want to display, if price Per Unit to be 4 decimal positions when necessary.
Math on this:
15.40 X 22.08 = $340.0320
340.03 / 15.40 = 22.0799
If Units are 1.00 and Total $ are $100.00
It should print price/unit as $100.00 (2 decimal positions). I...
I have a following code which gives me a different drive name in Window XP Professional or XP Home Edition. It works fine with Window 2000 or Win - 98.
for e.g., Window 2000 - "F:\data\<filename>
Window XP - "\\fs1\sys\data\"
<< code start >>
Local cDocLocation, cDataDir...
Dear Friends,
On my form, I have created a list box to look a specific directory which contains thousands of files. I want to see file name exactly UPPER/lower case (Originally stored) on a specific drive. I am using adir() function which is converting file name into UPPER case.
Is there any...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.