I have set a number of fields to auto enter related values, but when I create a new record I get an error: ‘Cannot save form data’ and the log file is full of ‘unknown source’ messages. (log file attached).
I have checked the relationship and if I perform a relookup subsequently it works, which implies that there is nothing wrong with the relationship itself.
Any ideas?
David is this rc11
Yes, rc11 on XP
I think this is the same issue I came across with. If so I know this will be solved in rc12…
OK - I can live with the workaround for now - thanks Marcel
hmm this looks a bit different then what i fixed for RC12
It would be nice to have a reproduceable example for this..
This issue still persists with rc13 - I haven’t been keeping close tabs on it due to other pressures but now I’ve come back to it and it still causes error messages in the log file (attached).
Specifically, I have one table with 6 or so fields set to get related values based on a simple id field match. When I enter a new record and manually edit the id field I get the error message “Cannot save form data” with no further details and the looked up values are not entered. But if I then perform a manual relookup the values are correctly entered.
Hope someone can solve this one!
I have now built a 2 file test app (testbed) to see if it is reproduceable and it is, on both Mac OS X and XP. Solution attached.
Import solution and go to form table1. Enter a 1 or a 2 into the number field - you are supposed to get a value in the text field looked up from table 2. Instead I get the error.
Click the relookup button and the value is copied across BUT… close the solution and reopen it and some or all of the copied values are missing again from table1 - on my Mac it is usually from the last record entered but on PC all the copied values are missing, even if a save is performed before closing!
It indeed a bug, it seems nobody ever used a lookup in tableview, will be fixed in Servoy 2.0.1
Thanks for the sample solution showing the problem.
You are correct - setting the form to list view and entering a record manually does indeed perform the lookup BUT… create a record and set the field by method and the lookup does not happen in my copy, even if view IS set to list.
I have tried a saveData step after the field has been set - no difference. A relookup step does get the information correctly.
In the solution attached to my last post try this: there is a method called ‘newRecordMain’ . Add the line ‘number1 = 1;’. I would have thought that this should cause the lookup to trigger - in my copy nothing happens, even with a saveData step added as well.
However, if you add a relookup after the field has been set then the lookup works. Is this the expected behaviour?
This is much more worrying -
if I close and re-open the solution any looked up values that were entered as a result of the relookup method step are gone, even if I save before closing. This also applies to any values that were looked up by clicking the relookup button. Only those lookups that were triggered by manually entering a value to trigger the lookup retain their data through a close and re-open.
Tested the same on both Mac OS X and Win XP Home with rc13