Note the ID column is identified as primary key of table.
Note: I have also experienced failure to SET VALUE of VARIABLES where it appears that the value is not being captured although the values are successfully returned in simple Data Base Queries.
Very peculiar and I am wondering if somehow the most recent updates have been corrupted on my system and if this is the case, how do I clean it up and totally reinstall ?
@wld try to click on server connection on „Options“. Click save again on your Mysql option windows, where you just leave username, password. etc. then click save so your server action is stored again. try it now. I had issues like u, as changes in my queries didnt have any effect to my queries.
The various tutorials indicate that it is not necessary to create a Global Post variable and that the update function will automatically display the unique ( primary) key in the table that is being updated. This will be displayed as the SQL function in both the columns and values panel as well as the conditions panel.
I first sent the the columns and values panel image, showing the incomplete SQL, the next image is the conditions panel showing the choice of the ID column, and the incomplete SQL. If the tutorials are correct than there is no requirement to set the post variable. Which is the correct method and why don’t my update actions reflect the apparent design ?
As soon as you select your table from the dropdown in the update record dialog, it adds the columns in the columns list and the identity column in the conditions tab and assigns a post variable to it.
Maybe your table is not properly configured and the identity column is not set as a primary key?
I understand that is how it is supposed to work. Select column and there is an assigned post value. The problem is that it is not working. Should I uninstall/reinstall Wappler ? And if so are there specific registry settings that have to be addressed.
If you are sure this is from the last update you can send us a debug log for further investigation as described in:
Do note that even if the primary field is automatically added to your filter, you should always check it and make sure the global vat exists and is named as you want as maybe the automatic naming is not always desired
