Revision 45989 trunk/org.gvsig.desktop/org.gvsig.desktop.compat.cdc/org.gvsig.fmap.dal/org.gvsig.fmap.dal.db/org.gvsig.fmap.dal.db.jdbc/src/main/java/org/gvsig/fmap/dal/store/jdbc2/spi/operations/ResultSetForSetProviderOperation.java
ResultSetForSetProviderOperation.java | ||
---|---|---|
311 | 311 |
// Muy probablemente si no tiene pk sea una vista, asi que |
312 | 312 |
// pasaremos de ordenar y esperemos que la vista este ya ordenada. |
313 | 313 |
select.disable_check_order_and_offset(); |
314 |
} else { |
|
315 |
for (String attrName : primaryKeys) { |
|
316 |
// Se precisa indicar un orden para usar OFFSET. |
|
317 |
// select.order_by().column(sqlbuilder.as_identifier(attrName)).ascending(); |
|
318 |
if(select.getOrderBy(attrName)==null){ |
|
319 |
select.order_by().column(attrName).ascending(); |
|
320 |
} |
|
321 |
} |
|
322 |
|
|
323 | 314 |
} |
324 | 315 |
} |
325 | 316 |
// } |
317 |
for (String attrName : primaryKeys) { |
|
318 |
if(select.getOrderBy(attrName)==null){ |
|
319 |
select.order_by().column(attrName).ascending(); |
|
320 |
} |
|
321 |
} |
|
326 | 322 |
if (limit > 0) { |
327 | 323 |
select.limit(limit); |
328 | 324 |
} else { |
Also available in: Unified diff