Can't remember how I did this.
I have a View connecting to a remote table that has the field names with an AS clause so I can name the resultant data fields. This is in the View Designer.
Now I need to add another view, and I can't remember how to get the AS clause in the select statement. I would prefer to use the View Designer and not write stand alone code.
TIA
Ron
Ron Seidl
Independent Developer
VFP
"I'm playing in life's theater in anticipation of a great cast party!"