Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Problem
Message
De
16/10/2003 08:46:21
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL Problem
Divers
Thread ID:
00839202
Message ID:
00839202
Vues:
56
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform