Hi...

Everytime I create a project, I have to run a sql to create view "serv". Below is the statement.

create VIEW SERV as select loop.loop_serv SERV, component.cmpnt_id,component.loop_id from component,loop where component.loop_id = loop.loop_id union select distinct '',0,0 from component,loop;

The statement is to allow a customize specification sheet to use the record from the component table. Once the sql is executed then I will login to the project in INtools and in the Instrument Specification module under the "Action" menu and "Specification Views", I will add new view as "SERV". I am still puzzle why sometime the view creation failed. It stated as "The specification view that you are trying to add is incompatible with your database structure". When this happen, I will drop the SERV view and rerun but creation still fail. I make a count from both the COMPONENT table and the SERV view. Their record is mismatch. Any idea how to solve this problem?

First of all if it’s asbuilt you need to create the view for each project.

The command is wrong you need to change it.

create VIEW SERV (cmpnt_id,loop_id,loop_serv) as select loop.loop_serv SERV, component.cmpnt_id,component.loop_id from component,loop where component.loop_id = loop.loop_id union select distinct '',0,0 from component,loop;

If you still get the same message probably because the system not except null in the loop_serv.

Ilan, this view creation is for every new project. And not for As-Built.