Messages

1

General Board / Re: Table in RTF report -

« on: December 04, 2007, 09:39:41 am »

just took me 40-odd minutes to solve the same problem, but it can be done.

I wanted to embed file>{ElemFile.FilePath}<file inside an element><element section.

I did it like this:
* activate the Element Section
* draw my table within it
* active the File section, add my content (FilePath) inside it
* Highlight and COPY the whole file>*<file section text
* DEACTIVE the File section, removing it from the doc
* position the cursor where the FilePath is required and PASTE

this pastes the markup code where it is required.. hope this helps..

2

General Board / Re: why canton is so popular?

« on: October 09, 2006, 06:30:26 am »

i like your thomas avatar.

3

General Board / Re: Bug: DB Relationship Roles

« on: October 11, 2006, 02:43:22 am »

Hi Paolo - i'm not sure if my issue is related to yours, precisely but the main problem i have with FKs is as follows:

* On a table, you cannot have two or more FK constraints referencing the same target key

I Have a UNIT table:

CREATE TABLE Unit (
UnitID NUMBER(12) NOT NULL,
Name VARCHAR2(32)
)

and i have a UNITCONVERSION table:

CREATE TABLE UnitConversion (
FromUnitID NUMBER(12) NOT NULL,
ToUnitID NUMBER(12),
Gradient NUMBER,
Offset NUMBER
)

I want to create TWO FK constraints from UNITCONVERSION to UNITS:

1. FromUnitID -> UnitID
2. ToUnitID -> UnitID

This is not possible in EA at this time.. It won't let you add the second FK, it updates the first changing the source key to a composite of FromUnitID and ToUnitID - unwanted.

L.

4

General Board / Re: Poss. Bug (797): HTML Documentation

« on: October 11, 2006, 02:28:51 am »

Morning..

We have fixed this issue now.. The solution was a combination of two things:

* Make the IIS MIME type changes, as above
* Configure ".dat" as safe in microsoft's crappy URLscan tool.

Cheers,
Lloyd.

5

General Board / Re: Poss. Bug (797): HTML Documentation

« on: October 03, 2006, 04:29:23 am »

Thanks Jeff - i will try that solution, albeit the webserver here runs IIS4 on NT4 Server.

Sounds more like a webserver config problem than an EA one.

Which app is reporting the message you quote ?

Does your webserver have permission to access the HTML files ?
Do the files have absolute path links in them ("C:\....." which the webserver does not translate correctly ?

1. The error message is reported by the index.htm page
2. Yes.
3. No. The URL which works is "file://///itgweb/datalogging$/Model/index.htm". It fails with "http://<SNIP>/datalogging/model/index.htm".

6

General Board / Poss. Bug (797): HTML Documentation

« on: October 03, 2006, 03:40:28 am »

Hello all,

Could anybody help me understand the following problem regarding the HTML Documentation generator?

In the documentation output folder, opening "index.htm" from my file explorer ("file://" scheme) works.

Opening "index.htm" via my webserver ("http://" scheme) returns this error message: "An error occured while loading data files, please confirm that all files have been generated and are intact."

Any ideas?

Many thanks,
Lloyd

7

General Board / Re: BUG: Premature FK deletion

« on: October 09, 2006, 06:26:36 am »

suffered this bug a lot recently.. i still have notes around my data model saying "recreate FK" after constraints have been deleted.