Servoy Forum

This has me stumped:
I have a column in a grid defined as a relation (e.g. abc_to_xyz.name) where abc and xyx are the names of the tables.
The error shows as an unresolved dataprovider in the designer.
In the problems console the error message is that the dataprovider does not exist.
The relation is correct. The column exists in the table.
It seems that the project clean does not correctly search and find the column.
I did have to delete the relation and redo it so that may trigger some kind of new uuid I suppose and that might cause the failure.
Deleting the grid column and then adding it back in does not resolved the dataprovider.
I have 5 relations like this that have unresolved dataproviders.
The grid 'myfoundset' is set to the separate foundset on the left side of the relation (e.g. 'abc' here).
How can I get rid of the warning and or fix the problem?

Tom
Using Servoy 2021.03.0.3642

Hi Tom,

Sounds odd, any chance you created the column outside Servoy?
Then there will be a warning that the column is missing from Servoy's table data providers but you can do a Quick Fix to add it to Servoy...

Hi Christian,
No the grid column is an aggregation - simple count done via the Servoy IDE.
It is like there is some IDE checker that might have 'remembered' an id and maybe I deleted the count and added it back in and it does not match?
When I go into the IDE and select the aggregation for the column dataprovider it correctly gets it but as soon as I lose focus on that dataprovider the checker reverts back to the unresolved.
When I run the application the data in the column is correct. So it must be related to the checker (anyone know the name of this checker and if I can delve into its mysteries - is it part of eclipse?)

pitc wrote:t is like there is some IDE checker that might have 'remembered' an id and maybe I deleted the count and added it back in and it does not match?

This can not be the case.
All relations and dataproviders are referenced by name not by ID.

Off-topic... Referenced by UUID are:
- forms
- valuelists
- functions (methods) assigned to event handlers
- media (ie. media assigned to label element. If used in another way, like a url media:///myImage.png, they are referenced by name of course)

Something that might be the issue though is that the relation is defined in another solution/module that is not in the child module-structure of the solution that holds this particular form.

Hope that helps