C
Cao Felix
Guest
I have some Java codes to get the ROWID when doing a OpenEdge database reading:
String query = "SELECT ROWID AS '"+rowid+"', ";
int size = columns.length;
for (int i = 0; i < size; i++) {
query += columns.getName();
if (i < size-1) query += ", ";
}
query += " FROM "+tableName;
However, the ROWID is not starting from 0. I have read http://knowledgebase.progress.com/articles/Article/21092 and understand what ROWID is, but my question is that how can I get the rowid starting from 0 to n? I know ROW_NUMBER is not supported so I wonder if there is any other way that anybody may know to save me here?
Continue reading...
String query = "SELECT ROWID AS '"+rowid+"', ";
int size = columns.length;
for (int i = 0; i < size; i++) {
query += columns.getName();
if (i < size-1) query += ", ";
}
query += " FROM "+tableName;
However, the ROWID is not starting from 0. I have read http://knowledgebase.progress.com/articles/Article/21092 and understand what ROWID is, but my question is that how can I get the rowid starting from 0 to n? I know ROW_NUMBER is not supported so I wonder if there is any other way that anybody may know to save me here?
Continue reading...