Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: From M$ to Linux and VB 6

Re: From M$ to Linux and VB 6

From: Brian Peasland <oracle_dba_at_nospam.peasland.net>
Date: Thu, 29 Jun 2006 00:04:40 GMT
Message-ID: <J1LHK4.Ey6@igsrsparc2.er.usgs.gov>


> 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_at_nospam.peasland.net
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
Received on Wed Jun 28 2006 - 19:04:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US