devin

Sorry not able to get work, not sure to have understood. I've a table, Table1, with these fields: Name LastName FullName I created a button, when pressed starts a script which create a dataset, and execute the query suggested, but I got an error : [Form_Table1] at line 9: SQL Error: SQL logic error: no such column: Name Can you explain? Thankyou! Attached the file I used. Regards. Devin

Hi, Are supported Sqlite Release 3.31.0 and calculated fields? otherwise, is there a way to automate field calculation in nsbase, except manual coding? For example, if i have a table with a field "Name" and a Field "Surname" I need to automatically have a field "Complete Name" as "Name Surname", which is automatically update in any "Name" or "Surname" variations string type in this example . Release 3.31.0 automatically supports this type of operations. thanks in advace. Bye. Devin

Good! Thanks!

Hi, Simple question, for which I didn't find a solution : how to copy and past (duplicate) a form and its scripts?

Found it! you can create a ("SQLQuery") dataset and execute an "UPDATE" statement using SQLite syntax my fault was I thogth only "SELECT" statement were possibly. Hope this could be useful for others. Best Regards Devin

Hi, I'm trying to do a conditional database update, I have a table with a boolean field "selected" which I use to flag if an item is selected (true-false). When I need to reset selection, I have to set all record field "selected" to "false". At the moment I do a for-next to set the field to all records, but it's really slow. Is it possible to do an "update" query with sql? or any way to do this task more quickly? Thanks. Regards Devin

Thank you @surfvite I'll try!

Hi everybody, Anybody knows how to execute a script (NSBASE/Lua) from an HTML block? My idea is to have an SVG Map and execute a script on clicking a certain area. Thank you! Best Regards Devin Erba