Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create cursor with alias names for column with space
Message
 
 
To
20/09/2018 06:19:55
Luis Santos
Biglevel-Soluções Informáticas, Lda
Portugal
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01662136
Message ID:
01662143
Views:
38
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform