Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Select SQL getting wrong fieldtype...
Message
De
06/11/2001 20:18:53
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Select SQL getting wrong fieldtype...
Divers
Thread ID:
00578319
Message ID:
00578319
Vues:
59
I have a SELECT SQL statement as follows:
vTempStr="sku as fSkuOur,desc as fDesc,price as fPrice,vend_id as fSkuVend,"+ ;
           "qty as fQtyIn,recno() as fRecno,'' as fPrnQty,price as fPrnPrice "+ ;
           "from product into cursor cTemp "
select &vTempStr
Everything appears to be working fine except for something I stumbled on by accident today....

The PRODUCT.QTY field is a numeric

the CTEMP.FQTYIN field is being set as character length 1

Not sure why or how this is happening, and in most cases it is working fine EXCEPT when I have qty amounts larger than 9 (1 single digit)... then of course the extra digits are being dropped.

I need to figure out why, and how to correct it... I need those larger figures.
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform