Hi,
When I try to execute :
SELECT DISTINCT( usuario ) FROM pfhocp10 ORDER BY usuario
I receive this exception :
Failed to go Record 1 of table pfhocp10:Failed to access file pfhocp10.DBF for it has been closed.
Error Code:393216
SQL State:60000
java.sql.SQLException: Failed to go Record 1 of table pfhocp10:Failed to access file pfhocp10.DBF for it has been closed.
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.dbf.j.a(Unknown Source)
at com.hxtt.sql.a2.a(Unknown Source)
at com.hxtt.sql.cx.a(Unknown Source)
at com.hxtt.sql.cx.a(Unknown Source)
at com.hxtt.sql.ev.s(Unknown Source)
at com.hxtt.sql.dn.a(Unknown Source)
at com.hxtt.sql.dn.a(Unknown Source)
......
......
......
Thanks in advance,
OSM
|
Failed to recur your issue through the following test sqls:
*create table if not exists pfhocp10 (usuario int, user varchar(10));
*insert into pfhocp10 values(123,'aaa');insert into pfhocp10 values(123,'bbb');
*insert into pfhocp10 values(456,'bbb');
*create index if not exists usuario on pfhocp10 (usuario);
SELECT DISTINCT( usuario ) FROM pfhocp10 ORDER BY usuario
Please email us your sample.
|
Well, I re-started hxtt service and work fine, but I worry this exception....
I'll send you our table
OSM
|
Main
webmaster@hxtt.com