Problem:

When an SQL project is created in Revolve, SQLCA does not appear as a copybook without manual intervention.  Why is this and how can this be avoided..?

Resolution:

SQLCA is not added automatically into a Revolve Project as it does in MFE.

MFE has functionality within it to know where to look for the SQLCA.  This functionality is not included in Revolve, the directory for the SQLCA has to be manually added.

To do this, a SEARCH DIRECTORIES has to be created in Revolve to tell it where to look for these kind of system items.

From the UTILITIES menu, choose OPTIONS.

Go to the SEARCH DIRECTORIES tab.

Create a new search directory.

Use the browse button next to the directory name, and find the MFE installation source directory.  In a standard installation, it is in     c:\\MFE\\SOURCE

Now using the DIRECTORY TYPE drop down list, choose COPYBOOK by single clicking.

NOTE :- If the project is not using the SQLCA provided with MFE,  but are using a special one created outside of MFE, the directory that contains the special SQLCA should be substituted in place of the c:\\MFE\\SOURCE\\ entry

Now use the ADD button.  This entry will appear in the CURRENT DIRECTORIES window / list.  Then click OK.

If this is a new project, add any components and the parser will find the SQLCA.

If it is an existing project, click on the MAKE icon (green triangle with a red tick).

The project will be re-parsed and the SQLCA member should be found and loaded.