Using Wappler 4.0.5 on a Mac with Node.
When opening some older queries in the query builder UI, the columns and conditions are blank, and the select statement resets to all, even though I have certain columns and conditions set. To modify the query, I have to completely rebuild it. If I click cancel, it still works.
Schema.
Earlier, the schema “dbo” was not really needed. But in one of the recent updates, it became necessary, breaking all existing queries from editing.
Note that they will RUN just fine. Just can’t edit as before.
Its a nightmare to fix. If Wappler update can fix it, it would be great.
What I did was open it in code view, and find & insert dbo. everywhere.
Thanks for the explanation @sid. It makes sense. Seems the “dbo” and “content” things has caused quite a few issues… I’ve been seeing it for a while but I’ve just re-created the queries but I’ve got a lot of changes to do on this project and it’s going to be a lot of extra work to go back and change these. Hoping @patrick can find a way to make it backwards compatible.
There has been same issue with asp classic 
too.
It is specifically with MS SQL server. I will have an other look at it to see if there is something I can do.
