MSSQL Re-edit of Query & Paged Query with View does not work

MH2ag · February 16, 2021, 7:57am

======== TEMPLATE BUG FORM ========

Wappler Version : 3.7.6
Operating System : macOS Big Sur
Server Model: NodeJS
Database Type: MS SQL
Hosting Type: Custom

Expected behavior

What do you think should happen?

After creating a query from a view it should be possible to edit it again.

Actual behavior

What actually happens?

On edit of the query (or paged query) I get the following error:

How to reproduce

Detail a step by step guide to reproduce the issue

A screenshot or short video indicating the problem

A copy of your code would help. Include: JS, HTML.

Test your steps on a clean page to see if you still have an issue

Create a query or paged query from a view and try to edit it after saving it.

George · February 16, 2021, 6:36pm

Please restart Wappler with logging, reproduce the problem and attach the debug log. See:

MH2ag · February 16, 2021, 7:09pm

Here my log file:
chrome_debug.log.zip (2.9 KB)

George · February 16, 2021, 7:16pm

How did you query look like?

MH2ag · February 16, 2021, 7:18pm

Pretty simple:

George · February 16, 2021, 7:26pm

tried it with all kind of tables in MS SQL Server and it works all fine to me…

could you try to recreate it?

MH2ag · February 16, 2021, 7:28pm

I already tried it a couple times. I will experiment with a simple query.
If I copy the query in the custom query it does work without error. It does only happen if I use the view.

George · February 16, 2021, 7:31pm

Could you add the generated action file as code block?

MH2ag · February 18, 2021, 7:06am

@George Could you replicate the issue?

Teodor · February 18, 2021, 7:00pm

This has been fixed in Wappler 3.7.7

Teodor · February 20, 2021, 4:00pm

This topic was automatically closed after 45 hours. New replies are no longer allowed.