I’m looking for guidance on design limits for insulated glazed units for a conservatory roof. Currently we have some units that are 3.5m long by 58cm wide. I have read suggestions that such a 6:1 aspect ratio for a roof unit is excessive. An article by The Window Man suggests that large aspect ratio units are more prone to explosion. Are there any concrete guidelines?
Connecting a mapping to a physical file so that files can be produced for other processes is a tortuous process. Running with multiple configurations in OWB allows all of the location and configuration detail to be setup in OWB.
OWB allows you to share locations between configurations. Thus a physical directory can be reused in your DEV TEST and PROD environments.
1. Create a location in the Files section of the Locations navigator. Ensure that the OS account that will be used to read the data can actually read the physical directory.
2. Make the location available (in Data Locations) in the relevant Control Center in the Locations Navigator.
3. Make the location in the Data Locations section of the relevant Module in your project in the Project Navigator. i.e. Edit the module and move the location into the Selected Locations list in the Data Locations section.
4. Configure the module to use the relevant location. The location is configured in the Identification section of the configuration.
The results of this process need to be deployed in Control Center.
Open the Control Center where the location should appear under the project container.
5. Register the location. Right click on the location under the project container and select the Register option.
6. Deploy the Connector. The reference to the files location is called a connector in Control Center. Find and select the location within the relevant database and deploy it by selecting the Create option and invoking the Deploy action. This will create a directory object in the Oracle database.
7. Deploy and execute the package that references the location. If this fails then it may be that the service account, that the Oracle database is running under, does not have permissions to the OS share or directory.
Simples!
Making a change to a location, such as changing a UNC path, requires that it is Unregistered in all of the Control Centers that it has been registered in. If you Edit the Location in the Locations navigator you will see a Registration view that shows all of the control centers where it has been registered.
Filed under: Uncategorized
Comparison groups can either be Family or Friend types. For Families an area may be classified into exclusive groups – Towns may be metropolitan or rural and can’t be both. For friend comparisons such as nearest neighbours an area will have different neighbours its own neighbours. Bristol adjoins BANES but BANES adjoining neighbours aren’t the same as Bristol’s.
If you have dba privs then …
SELECT * FROM dba_tab_partitions WHERE table_name = ‘T_Foo;
Else …
SELECT * FROM user_tab_partitions WHERE table_name = ‘T_Foo’;
There are a number of other views that are available in dba and user flavours.
Filed under: IT
Here’s the step by step guide http://spreadsheetpage.com/index.php/tip/creating_a_database_table_from_a_summary_table/
Filed under: Uncategorized
A task, or sub task, can be flagged in Project as requiring special attention. All tasks that include flagged sub tasks can then be shown easily by applying a column filter to the flag column.
The flag marker can be shown as a red spot to make it stand out. Insert a Flag column in the table view (right click on column headings and select “Insert Column” Choose a suitable field from the list e.g. Flag1. Customise the field by right click on field, choose “Costomise Fields” and then use the “Graphical Indicators” button to select the appropriate image.
Filed under: Uncategorized
MS Autorecovery keeps your valuable work in the following location…
C:\Documents and Settings\<user name>\Application Data\Microsoft\Office\Recent
e.g.
C:\Documents and Settings\recombinant\Application Data\Microsoft\Office\Recent
Note that the Application Data part of this path is a hidden directory that won’t necessary appear in Windows Explorer. You may, therefore, need to change your Folder Options in Windows Explorer or alternatively type the directory name in the address bar.
