Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ICASE cutting String
Message
De
12/10/2021 06:50:09
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
ICASE cutting String
Divers
Thread ID:
01682487
Message ID:
01682487
Vues:
62
Hello comunity,

I have VFP Cursor named mybolist with character field payment.
Then i need to select this cursor into a new cursor to create condition on payment Field.
select payment from mybolist
The Result is PAYPAL

When i write this new cursor:
select  Icase(payment='MB', 'MB', payment='CC', 'VISA', payment='PAYPAL','PAYPAL') as 'Payment'  into cursor Mycrs Readwrite
The result is PA  ??
To solve this problem i rewrite like this:
select  Icase(payment='MB', 'MB    ', payment='CC', 'VISA  ', payment='PAYPAL', 'PAYPAL') as 'Payment'  into cursor Mycrs Readwrite
The result inow is  PAYPAL
I deduced that the result must have the length of the string with more characters, why !?

Many thanks,
Luis Santos
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform