I guess $select is the best way to do it in Objectscript. It's not as intuitive as the other languages, but still it keep it simple and concise.

Thanks

Well, where I work we are all using Studio. I'll look into it tho. Do you know if it can be easily integrated with the menagement portal and if it lacks some important feature?

Thanks for the reference, I actually forgot about some of the shortcuts. I guess all the downside of the Studio editor can be solved with VS, but for me is not an option.

Would be great, but I don t have access to the java.sql package in my environment. Thank you for the answer anyway.

Yes in this case I can simply retrieve the ID SEQTAB.NextVal with another query. Thanks.