明细表添加查询条件报错
新建的明细表能够列出数据，但是添加查询条件进行查询时出现如下图所示的错误，敬请技术帮忙分析原因！
出错内容为：
reportId: 62 Error: SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"app_controls_3" = '第三项目部（周口德和）') ORDER BY app_controls_0,' at line 1 The SQL being executed was: select * from (select main.col_3315 app_controls_0,main.col_3316 app_controls_1,main.col_3317 app_controls_2,main.col_3318 app_controls_3,main.col_3319 app_controls_4,main.col_3336 app_controls_5,main.col_3337 app_controls_6,main.col_3338 app_controls_7,main.col_3339 app_controls_8,main.col_3340 app_controls_9,main.col_3341 app_controls_10,main.col_3342 app_controls_11,main.col_3343 app_controls_12,main.col_3348 app_controls_13,main.col_3349 app_controls_14,main.col_3350 app_controls_15,main.col_3351 app_controls_16,main.col_3371 app_controls_17,main.col_3372 app_controls_18,main.col_3373 app_controls_19,main.col_3374 app_controls_20,main.col_3375 app_controls_21,main.col_3376 app_controls_22,main.col_3377 app_controls_23,main.col_3379 app_controls_24,main.col_3380 app_controls_25,main.col_3381 app_controls_26,main.col_5148 app_controls_27,main.col_6132 app_controls_28,main.col_6134 app_controls_29,main.col_6135 app_controls_30,main.col_6136 app_controls_31,main.col_6137 app_controls_32,main.col_6388 app_controls_33,main.col_6391 app_controls_34,main.col_6392 app_controls_35,main.col_6730 app_controls_36,main.col_6731 app_controls_37,main.col_6732 app_controls_38,main.col_6733 app_controls_39,main.col_6734 app_controls_40,main.col_6735 app_controls_41,main.col_6736 app_controls_42,main.col_6737 app_controls_43,main.col_6742 app_controls_44,main.col_6743 app_controls_45,main.col_6744 app_controls_46,main.col_6802 app_controls_47,main.col_6803 app_controls_48,main.col_6804 app_controls_49,main.col_6805 app_controls_50,list.col_3353 app_controls_51,list.col_3354 app_controls_52,list.col_3355 app_controls_53,list.col_3356 app_controls_54,list.col_3357 app_controls_55,list.col_3359 app_controls_56,list.col_3360 app_controls_57,list.col_3362 app_controls_58,list.col_3363 app_controls_59,list.col_3367 app_controls_60,list.col_3368 app_controls_61,list.col_3369 app_controls_62,list.col_3370 app_controls_63,list.col_5152 app_controls_64,list.col_5961 app_controls_65,list.col_6806 app_controls_66 from app_data_273 main,app_data_273_list_3352 list where main.isdeleted = 0 and main.main_id = list.main_id and main.run_id in (911,914,915,917,933,934,990,992,996,1006,1011,1061,1085,1091,1096,1113,1129,1131,1139,1140,1156,1157,1158,1159,1160,1161,1165,1166,1167,1168,1170,1175,1178,1189,1196,1197,1199,1200,1202,1213,1222,1224,1226,1231,1232,1236,1238,1239,1240,1241,1242,1244,1263,1264,1265,1266,1267,1273,1274,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289,1290,1291,1293,1294,1295,1296,1297,1298,1299,1300,1301,1302,1304,1305,1306,1307,1308,1312,1313,1316,1317,1323,1324,1326,1329,1332,1338,1339,1341,1342,1343,1344,1345,1348,1349,1350,1351,1356,1359,1360,1362,1363,1364,1373,1376,1379,1380,1387,1389,1393,1395,1401,1402,1403,1404,1405,1406,1407,1411,1412,1414,1415,1416,1417,1419,1420,1425,1427,1429,1436,1440,1441,1449,1452,1453,1456,1457,1460,1461,1462,1463,1464,1465,1470,1471,1473,1476,1485,1486,1489,1493,1499,1500,1501,1504,1509,1511,1513,1516,1518,1519,1520,1525,1526,1557,1560,1561,1562,1565,1568,1578,1579,1580,1583,1584,1585,1587)) c WHERE ( c."app_controls_3" = '第三项目部（周口德和）') ORDER BY app_controls_0,app_controls_1,app_controls_3,app_controls_28,app_controls_34,app_controls_17,app_controls_20,app_controls_51,app_controls_52,app_controls_53,app_controls_57,app_controls_58,app_controls_59,app_controls_60,app_controls_63 LIMIT 0,20 我的理解是控件版的应用中心。bug很多。。。。用exl版吧。。欢迎交流66650164
页:
[1]