Database insert’s identity returning “INSERT”

Wappler Version: 4.2.0
Operating System: macOS Catalina (10.15.7)

Expected behavior

What do you think should happen?
I would expect to be able to use the identity value which gets returned from an INSERT call

Actual behavior

What actually happens?

When I try to use the identity of the newly added record in a follow on command I get the following message:
message: “select * from “a_demandrail” where “a_demandrail”.“id” = $1 limit $2 - invalid input syntax for type integer: “INSERT””

I’ve searched the forum and found the below entry. I’m using exactly the same configuration: nodejs & postgresql.

How to reproduce

The attached screenshot shows my failing API Action.

Community Page
Last updated: