Yama12
چهارشنبه 16 شهریور 1390, 11:51 صبح
سلام
من تو جاوا از این کد برای ضرب دو تا ستون در هم استفاده می کنم اما خطای زیر رو میده در حالی که در خود sql جواب درست میده ( اون خطی که با بقیه فاصله داره)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String Database="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
Database += FilePath.trim()+";DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection(Database, "", "");
Statement st2 =con.createStatement();
st2.execute(" SELECT DISTINCT temp1.vamOwnerAccount," +
" temp1.VamOwner," +
" temp1.LngVamID,"+
" temp1.zamenAccount," +
" temp1.AghsatAghabOftade," +
" temp1.OwnerMobile," +
" temp1.OwnerHomeTell," +
" temp1.OwnerAddress," +
" temp1.MablagheVam," +
" temp1.MablagheGHest," +
" temp1.MandeVam," +
" TblPersonInfo.StrFName AS zamenFname, "+
" TblPersonInfo.StrLName AS zamenLName," +
" TblPersonInfo.StrPhoneMobile AS ZamenMobile,"+
" TblPersonInfo.StrAddressMahallekar AS ZamenAddress,"+
" TblPersonInfo.StrPhoneManzel AS ZamenHomeTell"+
"temp1.AghsatAghabOftade * temp1.MablagheGHest AS Moavagh "+
" INTO SMS"+
" FROM (temp1 INNER JOIN"+
" TblPersonInfo ON temp1.zamenAccount = TblPersonInfo.LngAccountNumber)");
اینم خطا:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
من تو جاوا از این کد برای ضرب دو تا ستون در هم استفاده می کنم اما خطای زیر رو میده در حالی که در خود sql جواب درست میده ( اون خطی که با بقیه فاصله داره)
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String Database="jdbc:odbc:Driver={Microsoft Access Driver (*.mdb)};DBQ=";
Database += FilePath.trim()+";DriverID=22;READONLY=true}";
Connection con = DriverManager.getConnection(Database, "", "");
Statement st2 =con.createStatement();
st2.execute(" SELECT DISTINCT temp1.vamOwnerAccount," +
" temp1.VamOwner," +
" temp1.LngVamID,"+
" temp1.zamenAccount," +
" temp1.AghsatAghabOftade," +
" temp1.OwnerMobile," +
" temp1.OwnerHomeTell," +
" temp1.OwnerAddress," +
" temp1.MablagheVam," +
" temp1.MablagheGHest," +
" temp1.MandeVam," +
" TblPersonInfo.StrFName AS zamenFname, "+
" TblPersonInfo.StrLName AS zamenLName," +
" TblPersonInfo.StrPhoneMobile AS ZamenMobile,"+
" TblPersonInfo.StrAddressMahallekar AS ZamenAddress,"+
" TblPersonInfo.StrPhoneManzel AS ZamenHomeTell"+
"temp1.AghsatAghabOftade * temp1.MablagheGHest AS Moavagh "+
" INTO SMS"+
" FROM (temp1 INNER JOIN"+
" TblPersonInfo ON temp1.zamenAccount = TblPersonInfo.LngAccountNumber)");
اینم خطا:
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.