I have successfully queried for rowid. For some reason, row 1 and 2 always
have rowid 1, even when I create a new database. Do you have any idea why
that happens?
<Code>
rows = new Object[0][6];
rowid = new int[0];
try {
rsmd = rs.getMetaData();
//get row data
do {
//System.out.println(rs.getRow());
other_rows = new Object[rs.getRow()-1][6];
other_rows = rows;
other_rowid = new int[rs.getRow()-1];
other_rowid = rowid;
rowid = new int[rs.getRow()];
rows = new Object[rs.getRow()][6];
for(int j = 1; j < rs.getRow(); j++){
rowid[rs.getRow()-1-j]=other_rowid[rs.getRow()-1-j];
for(int i = 1; i < 7; i++){
rows[rs.getRow()-1-j][i-1]=other_rows[rs.getRow()-1-j][i-1];
//System.out.println(rs.getRow()-1-j+"::::::::"+other_rows[rs.getRow()-1-j][i]);
}
}
System.out.println(rs.getRow()+" "+rs.getInt(1));
rowid[rs.getRow()-1]=rs.getInt(1);
for(int i = 1; i < 7; i++){
//System.out.println(rs.getRow());
rows[rs.getRow()-1][i-1]=getNextRow(rs,rsmd).elementAt(i);
//System.out.println(rs.getRow()+"
"+getNextRow(rs,rsmd).elementAt(i));
}
}
while (rs.next());
</Code>
The bolded section always prints this out:
1 1
2 1
3 2
4 3
.... I'm not sure why
Eric
--
View this message in context:
http://www.nabble.com/Deleting-sqlite-rows-tp20412330p20440737.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
