>>Eview -- anyone know why field rule_id is invisible to eview? Eric do you use a field by that name in a temporary cursors, so the system thinks this field is part of it's data dictionary?
>
>I created a test table with a field rule_id, and a view from that table, and eview works fine on it.
>
>Is this a calculated field or something?
I have recreated the problem. It is not rule_id alone.
Create a table with fields "rule_id" and "rule".
Create a simple view off it.
Eview will see "rule" and other fields, but not rule_id
The following sample code will recreate the problem if it is run in a directory with no name conflicts and has a path to eview
create database test
open database test
set database to test
create table test (rule_id i, rule c(10))
create sql view lv_test as select * from test
use lv_test
do eview
Thanks
Gar W. Lipow