strMltLine += _cp.inColLineSeparator + strLine;
}
}
+ strMltLine += _cp.lineSeparator;
if(_isReplace){
if(!strMltLine.equals("")){
try {
}
}
} else {
- if (_cp.dbType == _cp.DB_TYPE_MYSQL){
- sqlLine = CmnUtils.split(strMltLine, _cp.SQL_TERMINATOR[_cp.dbType]);
- } else {
- sqlLine = CmnUtils.split(strMltLine, _cp.SQL_TERMINATOR2[_cp.dbType]);
- }
+ sqlLine = CmnUtils.split(strMltLine, _cp.SQL_TERMINATOR[_cp.dbType]);
for(int l = 0;l<sqlLine.length;l++){
- if(!sqlLine[l].equals("")){
+ if(!sqlLine[l].equals("") && !sqlLine[l].equals(_cp.lineSeparator)){
try {
+ CmnUtils.debugPrint("'" + sqlLine[l] + "'");
if (_cp.dbType == _cp.DB_TYPE_ORACLE){
_stmt = _dao.prepareSql(sqlLine[l].replaceAll("\r",""));
} else {