Submitted by Al on 2011/08/09 17:02
 
Get the following error when I refresh a grid. I'm using ver. V.
 
"Error reading data. Check the source, filter and sort criteria."
 
Tried recreating the grid with the same results. Other grids that are using the same data seem to be okay.

Comments

Hi Al.
 
Not to be too simplistic but that error usually means that you are asking IQ to do something it can't do because the source or filter or sort criteria are wrong.
Repeating the same circumstance will create the same problem
Suggested approach
 
Create a brand new grid
In source, leave it blank
In Filter, filter for field you are looking for
Don't sort
 
or
 
Create a brand new grid
In source, find the field that represents the data you want to see in the grid
In Filter, do nothing
In sort, do nothing.
 
In either case you should be seeing all the data you are trying to view.
 
If you need to filter the grid, i.e. dates, alpha numberic
then add that
 
If that works, then sort
 
I find most of the situations that you cite come from a conflict between source & filter
 
HTH

Al

2011/08/09 17:50

In reply to by jan_rifkinson

Thanks Jan, I've already tried that. The grid that is the problem is a grid that I'll been using as is for months, I haven't made any changes to it, just today I did a refresh and got the error. It seems I've had a few problems ever since I went to ver V.

Armando

2011/08/09 17:58

In reply to by Al

Did you download last V3 ? there was this bug in early Vs : IQ insists on putting my grid source inside [ ]
It's been fixed lately.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

No luck with V3, at least with V I had access to the data, just wouldn't sort. Now I can't see the data in the grid at all.

Pierre_Admin

2011/08/09 22:49

In reply to by Al

Hi Al,
 
Can you provide a screenshot of the grid with the source bar visible. If the alpha or date filter toolbars are enabled, show these also.
 
Thanks !
 
Pierre
 

Armando

2011/08/10 10:53

In reply to by Al

It appears that your source is enclosed in "[ ]". This was probably created by an earlier V version.
After removing the [ ], they shouldn't reappear with version V3.
 
--------------------------------------------------------------------------------
Windows XP Home Edition, Service pack 2
Dell Vostro 1500, Ram:3gb, CPU:Core2Duo T7500 2.2ghz

Al

2011/08/10 11:28

In reply to by Armando

That fixed it, the grid wasn't created with a earlier version of V, but the grid was created with a very early version of IQ. Thanks for the help.

Tom

2011/08/10 11:48

In reply to by Al

[quote=Al]
That fixed it, the grid wasn't created with a earlier version of V, but the grid was created with a very early version of IQ. Thanks for the help.
[/quote]
 
the "[ ]" bug was introduced with V or V1 but is reported as sorted in V3
 
 

Win 7 Pro 64bit ~ Portable latest IQ  (9.25.V3)