Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create cursor with alias names for column with space
Message
From
20/09/2018 07:11:06
 
 
To
20/09/2018 06:53:24
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:
01662139
Views:
51
>Hello António (bom dia)
>
>I need the column name with space like my cursor example, because my ERP have a built-in function ( listtohtml) that use the value of my cursor
>and create a list in HTML that i use to send on Body Email.
>
>Is that possible ?
>
>Best regards,
>Luis

No, it's not possible for DBFs and cursors, and it would be a terrible idea if it was.

I know that some database engines allow spaces in column names, and to read those tables into VFP you must change the column names. I also know people who have used spaces in column names, and regretted it afterwards since it caused many unexpected situations. Most people change the spaces into underscore.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform