Retrieve GUID identity MS SQL with PHP

[sbecks]

Wappler Version : 3.5.4
Operating System : Windows 10
Server Model: PHP
Database Type: MS SQL
Hosting Type: local

What do you think should happen?

Insert should return the GUID as identity.

What actually happens?

Nothing is returned

This was an issue from a while ago, I’ve worked around it but would like to resolve it. The issue is the same whether using MS GUID or creating UUID as MS SQL won’t allow these to be listed as identity columns…

Criteria for Identity?

Hi, I’m not getting an identity returned after inserting a record. [image] My ID field is a uuid (created from a custom formatter). It’s database field is user_id (in this instance). After insert I have a single query to retrieve the user just created by identity. The database insert is created fine. How does Wappler know the identity column to return and is there something in the insert above that stops it from being able to retrieve it? [image] Thanks!

I recently saw a solution for Node JS (and it looks like it works in ASP) so wondered if it were possible to solve for PHP?

Retrieve Identity not working for MS SQL and Node

You can try the following, edit the file lib/core/db.js. Line 76 looks like: if (ast.type == 'insert' && ast.returning && this.client.config.client == 'postgres') { Change it to: if (ast.type == 'insert' && ast.returning) { In you server connect action json file find the options for the insert step: "options": { "connection": "Target", "sql": { "type": "insert", "values": [ { Add an extra property to it: "options":…

Thanks!

[patrick]

We depend on 3rd party drivers for database connections. With PHP we use PDO and its method to get the identity (https://www.php.net/manual/en/pdo.lastinsertid.php).