>Hello. I ran into a little odd behavior that I would like to clear up.
>In my sql select statement I have;
>
>Select ..., SERVICE.DESC from mytable1, mytable2 .... where .... into cursor myresult order by myfield
>
>Service.desc is a not referred anywhere else in this statement.
>
>I'm using this sql select to gather data for a report. The odd thing is I'm expecting one of the field name to be "desc" from SERVICE.DESC, but instead I'm getting exp_5 as the field name. Since my report form is expecting DESC, it of course error out. So, I have to do something like this "...SERVICE.DESC AS DESC ". Seems a little odd to me that I have to do this.
>
>Does anybody no what is causing this?
>
>Thanks.
I think it happend because DESCending is reserved word in Foxpro.
--sb--