Hello
If the result of a SQL-SELECT query in VFP DBF has duplicate field names, Visual Foxpro adds "_A" to the first duplicate field and "_B" to the second.

If the query is run in SQL server via Sqlexec, the first field returns with the name unchanged, and the second with a "1" appended.

Is there any way to control this, that is, to get the same behavior? I have tons of reports that expect "_A" in field names.

Thanks!