Raised exception: Field not found

Raised exception: Field not found

Postby mzwollo » Fri 03 Oct 2008 12:35

create table test (id char(5) not null, datum date not null);
commit;
alter table test add constraint pk_test primary key (id,datum);
commit;
insert into test (id, datum) values ('08001',cast('01.01.2008' as date));
insert into test (id, datum) values ('08001',cast('01.02.2008' as date));
insert into test (id, datum) values ('08001',cast('01.03.2008' as date));
insert into test (id, datum) values ('08002',cast('01.02.2008' as date));
insert into test (id, datum) values ('08002',cast('01.03.2008' as date));
insert into test (id, datum) values ('08003',cast('01.03.2008' as date));
commit;

select distinct datum from test order by datum;

raised exception: "field id not found".
mzwollo
 
Posts: 2
Joined: Fri 03 Oct 2008 12:32

Postby Plash » Mon 06 Oct 2008 09:27

Probably this is internal exception in dbExpress that is not shown to the user. You can do the following to resolve the problem:
Open Tools | Options; select Debugger Options \ CodeGear Debuggers \ Language Exceptions category, and uncheck 'Notify on language exceptions' checkbox.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby mzwollo » Mon 06 Oct 2008 12:59

Thank you.
Your advice works.
Regards, Martin Zwollo
mzwollo
 
Posts: 2
Joined: Fri 03 Oct 2008 12:32


Return to dbExpress driver for InterBase & Firebird