You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I am using the PgSql database and using the below command to fetch specific columns.
QSqlError daoError = qx::dao::fetch_by_query(query, items, NULL, columns);
where the query is a normal query, items is the return from the query, the connection is NULL and columns are as mentioned below:
QStringList columns = QStringList() << "column1" << "column2";
Now the issue is I am not getting any daoError but I am also not getting specific column1 and column2.
I was using the same in MySql and it was working fine.
When I remove the columns parameter I get all the columns without any error.
I wanted to know if I am using the correct command, if not what would be the correct syntax?
Let me know if you need something more from my side.
The text was updated successfully, but these errors were encountered:
Hello,
I think you are using the right command, I don't understand why it doesn't work for you with postgreSQL (I have several customers which use postgreSQL without any issue).
Have you tried to execute the SQL query generated by QxOrm library (you should see it in the output logs) in pgAdmin for example ?
I am using the PgSql database and using the below command to fetch specific columns.
QSqlError daoError = qx::dao::fetch_by_query(query, items, NULL, columns);
where the query is a normal query, items is the return from the query, the connection is NULL and columns are as mentioned below:
QStringList columns = QStringList() << "column1" << "column2";
Now the issue is I am not getting any daoError but I am also not getting specific column1 and column2.
I was using the same in MySql and it was working fine.
When I remove the columns parameter I get all the columns without any error.
I wanted to know if I am using the correct command, if not what would be the correct syntax?
Let me know if you need something more from my side.
The text was updated successfully, but these errors were encountered: