Re: From M$ to Linux and VB 6

find out what's appending the ",col1.rowid " (which appears to be SS specific) and remove that piece of code.

I agree that the OP needs to figure out what is appending the extra column to the SELECT clause. That is the root of the problem.

But I do know that this is not SS specific. SS does not have the ROWID psuedo column as Oracle does. When I type the following query into one of my SQL Server instances:

select custid,rowid from compmon;

I get the following error:

Server: Msg 207, Level 16, State 3, Line 1
Invalid column name 'rowid'.

And prepending ROWID with the column name does not help either. For that, I get the following error:

Server: Msg 107, Level 16, State 2, Line 1
The column prefix 'custid' does not match with a table name or alias name used in the query.

This error leads me to believe that I would prepend with the table name instead, but that just leads back to the Msg 207 error.

Cheers,
Brian




--
===================================================================

Brian Peasland
oracle_dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown
.