Valuelist fully loaded

Classic Servoy
1

I’m getting an error in the console, the first time that I click into the data entry form,

Valuelist contact_id fully loaded with 500 rows, more rows are discarded!!

It doesn’t seem to happen if I exit the form and then go back in.

When I try searching globally for “contact_id”, Servoy appears to return only text results from code (.js) files, where “contact_id” is, say, part of a field name. It does not point to data provider objects on the form/subforms where this valuelist might be attached.

In tracing the onShow method for the form, I thought it might be coming from a read-only, table-view subform (in a tab panel), which includes a column for svc_student_contact_id – a foreign key to a student_contact table. I’m using contact_id as the valuelist for a column (type_ahead type). I changed all data providers on this form that were type_ahead to text_field, and I changed from using the contact_id valuelist to using a relation. But these changes did not make a difference, I still got the error.

These columns are read-only.

Is there a way to find the source of this console error?

Thank you,
Don

2

Hi Don,

much has been discussed around here already.
take a look here (for example): https://www.servoy.com/forum/viewtopic.php?f=22&t=15851

3

Hi Mark,

Thanks for that. I think I found the problem on two drill-down forms – the “Search for references” is very useful.

Although I read through that thread, I didn’t fully understand it. The valuelist is table-based rather than global. But it looks like I was offering all possible values in a combobox, rather than offering only related values.

Thanks again,
Don