Not sure what are you doing exactly, but a simple insert custom query returns the identity of the last inserted record …
Can I then use the ‘identity’ from the custom query in a SELECT query after it? I can’t see an ‘identity’ appearing in the Server Data Bindings? Because I don’t see any ‘Identity’ for there custom query, only the scheme I manually put in which I believe doesn’t do anything.
So your whole issue is that you don’t see the identity in the data picker?
You can just manually enter it, switch to code in the data picker and add it manually like:
@George will check why is the identity not being displayed in the data picker.
@Teodor yes that is my issue. Sorry I am still a little confused, where am I manually entering the identity exactly?
In the customer query or the next query I want to use the identity of the custom query?
well here:
where you expect it to be available for picking
Got it working! Yay! Thanks! So the whole issue was the fact that ‘identity’ was not being displayed for custom queries in the Server Data bindings. thanks for helping me with a work around with the custom code.
So, it is the name-of-custom-query.identity
1 Like
I’ve learnt something too. Didn’t realise that custom INSERT queries returned the identity…
2 Likes