Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Problem
Message
From
16/10/2003 08:46:21
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL Problem
Miscellaneous
Thread ID:
00839202
Message ID:
00839202
Views:
57
I have the following sql statement as the recordsource of a grid:
SELECT wdesc,fractionconv(dim) AS dim,lb_ft,hr_ft FROM weld_xx ; 
	INTO CURSOR curWeld WHERE !DELETED() ORDER BY wdesc,dim
fractionconv() converts the field value (numberic) to a fraction (character) (i.e. .25 to 1/4). Everything seems to work fine except certain values are truncated as follows:
1/4
2/3
5/16
11/1  --- should be 11/16
3/4
1/2 
1 1/4
15/1  --- should be 15/16
What am I missing?

Thanks in advance for your help,
Russell
Next
Reply
Map
View

Click here to load this message in the networking platform