sql server odbc: I'm using SQL Server 2K and VFP8.

When I save a record, the following ODBC Error Message is displayed.

'Column Name [RefNo] appears more than once in the result column list.'

I suspect it means exactly what it says, that a column name is used more =
than 2X. Likely VFP doesn't know how to determine which column to =
update. I'm not a VFP expert, but you might want to use SQL Profiler to =
see if the command is event getting to the server. You might also try =
googling on the actual error number you're getting.=20
--=20

Brian Moran
Principal Mentor,=20
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com


[quoted text, click to view]
I'm using SQL Server 2K and VFP8.

When I save a record, the following ODBC Error Message is displayed.

'Column Name [RefNo] appears more than once in the result column =
list.'