Hi Max,
I can't send a minimal example, since that works. But in my complicated form I have a save db action that takes 16 fields. In the data I can see they all exist. But the debugger shows me a query that leaves out the last one. Is there a restriction to the number of fields? I have done tons of tests, but can't find anything that could cause the behavior.
Maybe there are checks or things in the code that can affect the generation of the update query in a save db action that might help to solve this problem.
I will also post another issue (maybe related).
Kind regards,Pim
Hi Pim
Do you have the Modify Data Source behavior enabled ? if yes then only fields defined there will be stored, same if you use the Table Fields behavior.
Hi Max,
I had modify data source enabled before on this field, but that did not work as expected. So I solved it differently and removed it. Could that be the cause?
I also had all the relevant table fields added in the save db action, this is not changed. I even tried removing and adding again. No luck either. The only way to solve is by setting the database to insert a default value (okay for now, to continue testing) when not receiving any value.
I even checked if there was a 'space' in the name (hardly visible, but not the case).
Any other thoughts and things to check?
Kind regards,Pim
What is the name of that table field ?
How did you solve the modify data issue ?
Hi max,
Thanks for the quick responses. The field is called aanmelddatum (dutch for registration date). This field has to be updated and was originally entered by a default in the database, which takes the value now().
So my initial attempt with modify data was to add this value and setting it to now(). But this does not work here, but does in some other sql generating parts like in the read db action.
Solution was to create the current date in php and add that variable to the dataset that has to be stored. No modify data was then needed. Value was okay, but the field was not included in the query eventhough it is in the table fields listing.
Although I think this might be some sort of bug, I am no longer using this either. I write the registered date later, so no updating is needed, just the sql default at generation of the record.
Kind regards, Pim
Hi pimh
now() in modify data source will not work, SQL functions are not supported there, you had to do set it using PHP as you did, well done.
