QtSql:QSqlRecord不保留表前缀

字段名完全依赖于驱动程序;所以问题实际上是SQLite本身的问题,毕竟它可能做的是“正确的”事情(正确的,就像SQL标准一样,我没有检查)。

select * from :

SELECT t1.id TI_ID, t1.name TI_NAME, t2.id T2_ID FROM table1 AS t1, table2 AS t2 WHERE t1.table2_id=t2.id

我也发现了这个问题,但发现如果您使用QSqlQueryModel创建QSqlRecord,它可以正常工作:

QSqlQueryModel *model = new QSqlQueryModel;
model->setQuery("SELECT t1.id TI_ID, t1.name TI_NAME, t2.id T2_ID FROM table1 AS t1, table2 AS t2 WHERE t1.table2_id=t2.id");

int TI_ID          = model->record(0).value("TI_ID").toInt();
int TI_ID          = model->record(0).value(0).toInt();
QString TI_NAME        = model->record(0).value("TI_NAME").toString();
QString TI_NAME_from_id= model->record(0).value(1).toString();