Attachment #116104 for bug #206470

This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

View | Details | Raw Unified | Return to bug 206470
Collapse All | Expand All




                    int[] rows = getSelectedRows();
                    String insertSQL = "";
                    for (int j = 0; j < rows.length; j++) {
                        int modelIndex = convertRowIndexToModel(rows[j]);
                        Object[] insertRow = dataView.getDataViewPageContext().getCurrentRows().get(modelIndex);
                        String sql = dataView.getSQLStatementGenerator().generateRawInsertStatement(insertRow);
                        insertSQL += sql.replaceAll("\n", "").replaceAll("\t", "") + ";\n"; // NOI18N
                    }

                int[] rows = getSelectedRows();
                String rawDeleteStmt = "";
                for (int j = 0; j < rows.length; j++) {
                    int modelIndex = convertRowIndexToModel(rows[j]);
                    SQLStatementGenerator generator = dataView.getSQLStatementGenerator();
                    final String deleteStmt = generator.generateDeleteStatement(modelIndex, getModel());
                    rawDeleteStmt += deleteStmt + ";\n"; // NOI18N
                }
                ShowSQLDialog dialog = new ShowSQLDialog();

Return to bug 206470

Lines 377-383 Link Here

(-)a/db.dataview/src/org/netbeans/modules/db/dataview/output/DataViewTableUI.java (-2 / +4 lines)
377	int[] rows = getSelectedRows();	377	int[] rows = getSelectedRows();
378	String insertSQL = "";	378	String insertSQL = "";
379	for (int j = 0; j < rows.length; j++) {	379	for (int j = 0; j < rows.length; j++) {
380	Object[] insertRow = dataView.getDataViewPageContext().getCurrentRows().get(rows[j]);	380	int modelIndex = convertRowIndexToModel(rows[j]);
		381	Object[] insertRow = dataView.getDataViewPageContext().getCurrentRows().get(modelIndex);
381	String sql = dataView.getSQLStatementGenerator().generateRawInsertStatement(insertRow);	382	String sql = dataView.getSQLStatementGenerator().generateRawInsertStatement(insertRow);
382	insertSQL += sql.replaceAll("\n", "").replaceAll("\t", "") + ";\n"; // NOI18N	383	insertSQL += sql.replaceAll("\n", "").replaceAll("\t", "") + ";\n"; // NOI18N
383	}	384	}
Lines 401-408 Link Here
401	int[] rows = getSelectedRows();	402	int[] rows = getSelectedRows();
402	String rawDeleteStmt = "";	403	String rawDeleteStmt = "";
403	for (int j = 0; j < rows.length; j++) {	404	for (int j = 0; j < rows.length; j++) {
		405	int modelIndex = convertRowIndexToModel(rows[j]);
404	SQLStatementGenerator generator = dataView.getSQLStatementGenerator();	406	SQLStatementGenerator generator = dataView.getSQLStatementGenerator();
405	final String deleteStmt = generator.generateDeleteStatement(rows[j], getModel());	407	final String deleteStmt = generator.generateDeleteStatement(modelIndex, getModel());
406	rawDeleteStmt += deleteStmt + ";\n"; // NOI18N	408	rawDeleteStmt += deleteStmt + ";\n"; // NOI18N
407	}	409	}
408	ShowSQLDialog dialog = new ShowSQLDialog();	410	ShowSQLDialog dialog = new ShowSQLDialog();