Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create cursor with alias names for column with space
Message
 
 
À
20/09/2018 06:19:55
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01662136
Message ID:
01662143
Vues:
40
>Hello community,
>
>I need to build a cursor in VFP but i want to change the columns names, the problem is that the alias name for my column have space and VFP return error:
>Example:
>
>
>SELECT condpag as ' Condições Pagamento', valoreur as 'valor Euro' FROM M_PEND INTO CURSOR CRSLIST READWRITE
>
>How can solve this problem.
>
>Many thanks,
>Luis

Hi Luis,

Can you make a slight change in that program so it would split the column names based on the case? Say, it finds upper cased letter in the string and it splits it into two words.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform