On Wednesday 30 March 2005 10:49 pm, Keith wrote: > I believe ROWID is not part of the table but an artifact of the query > result (i.e. temporary query result table). Your statement SELECT ROWID > FROM TABLE implies ROWID is an actual field when it is not. A table with > no primary key has a hidden serial field called SYSKEY, but this is not > ROWID. > > SELECT AD_CLIENT_ID, ROWID > FROM AD_ACCESSLOG > > would return a result in the ROWID result field. > > If I am incorrect, someone please speak up. > > > Keith Arnold > The Boxer Group > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 30, 2005 3:11 PM > To: Keith > Subject: RE: ROWID Problem with MaxDB 7.6 BETA Release > > > Hello everybody > I hope this explain my problem. > First a want to create this table in SQL Studio - Oracle Mode for MaxDB 7.6 > NOTE THAT FINISHED WITH ROWID STATEMENT > Create Table "AD_ACCESSLOG" ( > "AD_ACCESSLOG_ID" Integer NOT NULL , > "AD_CLIENT_ID" Integer NOT NULL , > "AD_ORG_ID" Integer NOT NULL , > "ISACTIVE" Char(1) NOT NULL Default 'Y' Constraint "SYS_C0017953" > Check > (IsActive in ('Y','N')) , > "CREATED" Date NOT NULL Default SYSDATE , > "CREATEDBY" Integer NOT NULL , > "UPDATED" Date NOT NULL Default SYSDATE , > "UPDATEDBY" Integer NOT NULL , > Primary Key ("AD_ACCESSLOG_ID") > )ROWID > Statement successfully executed. No Result > Execution Time: 15:23:46.703 - 15:23:46.749 (00.046 sec) > > Then in the SQLStudio using MaxDB 7.5 Kernel get the next message > SELECT ROWID FROM AD_ACCESSLOG > Statement successfully executed. No Result > Execution Time: 15:25:25.203 - 15:25:25.233 (00.030 sec) > But when i try to do the same statement for MaxDB 7.6 it isn�t work and get > the > next message. > > ---- Error ------------------------------- > Auto Commit: On, SQL Mode: Oracle, Isolation Level: Committed > Column not found;-4005 POS(8) Unknown column name:ROWID > SELECT ROWID FROM AD_ACCESSLOG > > ONLY WANT TO KNOW BECAUSE OF THIS? > > Mensaje citado por Keith <[EMAIL PROTECTED]>: > > I believe ubravo may be referring to the ROWNO predicate. Though the > > documentation states > > it can only be used in the WHERE clause, I have used it successfully in > > the > > > SELECT statement in 7.5 . > > > > Keith Arnold > > The Boxer Group > > > > -----Original Message----- > > From: Zabach, Elke [mailto:[EMAIL PROTECTED] > > Sent: Thursday, March 24, 2005 12:32 AM > > To: [EMAIL PROTECTED]; [email protected] > > Subject: AW: ROWID Problem with MaxDB 7.6 BETA Release > > > > [EMAIL PROTECTED] wrote: > > > I have a create table script that don�t get the rowid column in this > > > version > > > 7.6. Using SQLStudio to execute this script. Anyone can help me!! with > > > this > > > problem. Before I create this table the rowid column (Internal) doesn�t > > > exist. > > > > Sorry, but I (and perhaps not only me) do not really understand your > > problem. > > Do you want to create a table or do you want to alter it? > > What do you mean with rowid-column? A column named ROWID, a datatype (not > > existing in MaxDB), the column named SYSKEY in MaxDB (the internal > > primary key if no user-defined one is specified) not ROWID as perhaps in > > the database system your were using before? > > Which error is returned? Your ' don�t get' is not very specific. > > > > Elke > > SAP Labs Berlin > > > > > -- > > > MaxDB Discussion Mailing List > > > For list archives: http://lists.mysql.com/maxdb > > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > > MaxDB Discussion Mailing List > > For list archives: http://lists.mysql.com/maxdb > > To unsubscribe: > > http://lists.mysql.com/[EMAIL PROTECTED] I was using maxdb version 7.5 and creating tables in mode Oracle using ROWID , then I make a simple select stataments in Internal mode like "Select rowid, fieldname1, fieldname2,... from tablename " and I've got no problems but when using maxdb version 7.6 i've got "Unknown column name:ROWID"
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
