Author Topic: Accessing the underlaying database (Read 7821 times)

Michel777 · « **on:** July 25, 2013, 05:43:04 am »

Hi,

I#d like create my own reports based on the underlaying EA database. How to acces it ?

This one here doesn't work for me: http://community.sparxsystems.com/community-resources/author/558-beginner

Thanks,

Michel

qwerty · « **Reply #1 on:** July 25, 2013, 07:18:00 am »

You're referencing all of my publications. Which one do you refer to? The LaTeX PDF generation. If so, you should check eaDocX. It's based on MS Word and might be more convenient for you.

q.

Michel777 · « **Reply #2 on:** July 25, 2013, 05:00:58 pm »

Hi,

of course the "Accessing the Database".

Michel

Stefan Bolleininger · « **Reply #3 on:** July 25, 2013, 05:10:24 pm »

Hi,

querty has a really valueable book written for this.

Depending on the type of "reports" you will have to dig into the database, or you don't even have to.

In my cases i go the following path:

1. Look at the internal report generator: Does it give you the feature you want to have?
2. Is it possible to build the information into the "normal" report by using the template fragments (really useable for reuse ;) )
3. Do i need some sql-queries for it
4. Is it extraordinary and do i really need it?
5. Create a script/addin

Best regards

Stefan

qwerty · « **Reply #4 on:** July 25, 2013, 06:57:33 pm »

Quote

Hi,

of course the "Accessing the Database".

Michel

So what kind of reports are you after? (Doesn't seem to be the usual RTF-stuff.)

q.

Michel777 · « **Reply #5 on:** July 27, 2013, 05:43:32 pm »

Hi,

I'd say they are more statistics, then reports. I need access on the the database and the model, of course - except, it is possible the build the model from the database.

Thanks,

Michel

qwerty · « **Reply #6 on:** July 27, 2013, 07:22:59 pm »

In that case my Inside book would be first choice. If you have a specific question you can post here or write me a mail.

q.

Michel777 · « **Reply #7 on:** July 27, 2013, 09:06:35 pm »

Hi,

select * from t_attribute: empty result set. The coulumn headers are adjustetd to the corresponding tables, but the list is empty.

Any idea ?

Michel

qwerty · « **Reply #8 on:** July 27, 2013, 10:31:49 pm »

What do you expect to find? t_attributes contains the class attributes.

q.

P.S. In any case: a more detailed problem description would save a lot of frustration on both sides.

Michel777 · « **Reply #9 on:** July 27, 2013, 10:37:59 pm »

Hi,

problem solved. Obviously i tried to get data from table, tehy are empty, like the example table t_attribute.

Thanks for patiente,

Michel

qwerty · « **Reply #10 on:** July 27, 2013, 11:57:24 pm »

All beginnings are difficult :-)

q.

Michel777 · « **Reply #11 on:** August 03, 2013, 02:18:51 am »

Hi,

opening an *.eap file with MS Access 2013 causes the following error: "cannot open a database creaeted with a previous Version of your application" .

The suggested workaround "comptact" the database causes the same error. Any idea ?

Thanks a lot in advance,

Michel

Stefan Bolleininger · « **Reply #12 on:** August 03, 2013, 03:15:40 am »

Hi,

this was an error I had in the very early ages and have still no idea about it.

My Workaround:

rename The eap into *.mdb for the access file.
Open the mdbfile as an odbc-database in the openoffice base (Database application).

In all of my cases it works quite good :-)

Regards

Stefan

qwerty · « **Reply #13 on:** August 03, 2013, 03:22:36 am »

Might be a Jet3/4 issue. Probably you use Jet3 based EAP files. I once switched my base model to Jet4 (you can download that somewhere on a Sparx page).

q.

Stefan Bolleininger · « **Reply #14 on:** August 03, 2013, 04:50:48 am »

I think it is something in relation to the version of MS access. '97, 2000, 2003 ...

Regards

Stefan

Sparx Systems Forum

News: