Also, you might try turning off the 'editable queries' in the options. That causes it to do a select rowid, * from table, so that once you edit the grid, it will use the rowid to go back and actually make the update to the data.
-----Original Message-----
From: Kevin Lange [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 14, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: strange SQL with TOAD
Do you have the Option, Show Rowid enabled under Options/Data Grids-Data ??
-----Original Message-----
Sent: Tuesday, January 14, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
List,
We use TOAD as one of our database tools and I was viewing some of the
SQL statements that were processed and I can't explain the "why" the
statement is the way it is.
The developer wrote "Select to_char(sysdate,'mm-dd-yyyy') from dual;"
in a VB application.
We use the Oracle and MS ODBC drivers to connect to the database.
What I saw as the SQL statement: "select
ROWID,to_char(sysdate,'mm-dd-yyyy') from dual where ROWID = :v1"
Where did the select ROWID come from?
In other statements where the select written is "Select table.* ..." I
see "Select table.ROWID, table.*..." Again, where does the ROWID come
from?
Is it a VB,/+ODBC thing that I should not be concerned with?
Any links to the info would be helpfull in understanding the query.
Thanks,
Ron
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ron Rogers
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Kevin Lange
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
