Submitted by Armando on 2009/02/12 17:15
In one grid, I always get the :
"Error reading data : Check the source, filter and sort criteria"
whatever I write in the source/filter/source/"any other" bar. It can even be completely empty -- still get the error.
Tried a restart, tried a repair --> still get the error.
What could be the problem?
Anybody else had this problem before?

Comments

I found the problem, but not sure how to truly solve it (apart from renaming  some fields --> see below).
 
The problem doesn't seem to be really related to the error message ( so that should probably be fixed ) :

 a field's data("Day") -- displayed  in the grid -- seemed to depend on a field which name was changed by me (the "Date" field -- changed it to another name). I can't find how, where and at what level these two fields are related, but they seem to be since one affects the value of the other.
 
Suggestion : if these are "system" fields and shouldn't be renamed, maybe they could be changed accordingly ?

Pierre_Admin

2009/02/12 18:08

Permalink

Bingo!
 
The Day field is a DB generated field. In Field Management > Options, you'll see the definition of this field:
 
<source>SELECT ItemID, Format([Date],"ddd") AS Day FROM ¯qDate;</source>
 
Such a field, does not take up any space in the IQBase. It is a live link to another field (this is advanced stuff!). In this case, it returns the day of the week
 
If you want to keep this and you've changed the [Date] field name, simply update this SQL definition

Armando

2009/02/12 18:39

Permalink

Thanks Pierre. Funny how I checked everything... but the option section. Hehe.
I decided that "day" would remain "day" and so won't have to rename any parameters for now.
However, this live linking could be useful for other fields involving data reformatting, I suppose.