Dynamic relations and foundset

Classic Servoy
1

Hello,

i have a foundset and I add a new record (without save), then i create a new dynamic relation but the relation isn’t connected to the last record added to the foundset.

I have the necessity to connect my dynamic relation to the new record on the foundset, is there any possibility to do it?

thanks

2

Post your code.

3

I assume by ‘dynamic relation’ you mean you created a relation via the solutionModel or have a relation based on a variable?

Anyway the problem is that you need to handle 2 separate foundsets here.

If you create a record in foundset A (and you don’t save it)
Then try to fetch this record via a relationship (which will create a foundset B)
Now, in order to create foundset B, Servoy will execute a query (pls look at the admin pages to see this happening)
Because you didn’t save the record yet, the record isn’t in the database and Servoy won’t be able to find your record.

Hope this explains why it doesn’t work.
If you want an answer to solve the problem pls. post code and a detailed explanation of what exactly you are trying to achieve.

4

The only solution is that to save the new record and then create a new dynamic relation.

Thanks a lot