Dan Lewis wrote:
Bottom post
On Saturday 17 September 2005 09:43 pm, Fred Frazelle wrote:
Dear Pablo --
Thanks a lot for your indications. i checked them out and they
would be great for someone with quite a bit of computing skill and
knowledge but one of the things i´m hoping to see with this new
version of OO is something simple enough that a straightforward left
join can be established on two tables which have been created through
the Oo interface, a query made up which brings up the info from both
tables and which would also allow you to begin inputting information
or which could serve as the base upon which you could create forms
and reports. The instructions which i read still require, however
little, some code writing (not to mention understanding of what is
going on behind the scenes) and i´m afraid the managers in my office
aren´t all that interested in sending my co-workers to classes in
Postgresql or HSQL programming just to be able to set up a couple of
related tables input the info and run some queries on them. Gee, i
had no idea it would be this tough...
Anyway, Have a nice evening! :-)
Pablo Lachmann wrote:
Hi!
Am 17.09.2005 um 17:19 schrieb Fred Frazelle:
Val, have you added any data to the tables yet and if so, how
have you done this? i have been trying to do this for several
months now by creating the two tables and then creating a query
upon which to base my input form and reports but when i go to try
and input the first row, the query comes up blank -- there is no
first row from the left join of the two tables. If i create a
form based on the query, no data can be input into the fields.
I don't know if I understood you correctly, but do you have two
tables and want to insert some data in both of them? If this is
what you intend, check the following tutorial:
http://documentation.openoffice.org/HOW_TO/data_source/link_tableht
ml/
link.html#9.Creating%20a%20Form%20for%20the%20Data%20Source|outline
(one line)
First I tried to use a query for my form, but I could not edit any
data. The way it is described in the tutorial works for me.
Gruesse, Pablo
If you are using one of the 1.9.x developer snapshots, have you
tried using "View" in the "Table" section?
Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Dear Dan, thank you for your concern. i liked your answer. It was
pretty short. i´m not at all familiar with views but i went ahead and
began to experiment. When i tried to set up the two tables and make the
connection from the first table ID to the second table on its key_events
(as a foreign key) and then tried to save the View, i got the following
Base error:
"Error while connecting to the data source", and then...
Column already exists in statement [SELECT
"Employees"."ID","Employees"."FirstName","Events"."ID","Events"."EventDescription","Events"."key_events"
FROM "Events" "Events" LEFT OUTER JOIN "Employees" "Employees" ON
"Events"."key_events" = "Employees"."ID"]
Even when i take the "sub" or dependent table off of the View area,
save the View and run it, all it gives me is just the list of the fields
across the top, but there is no way to input data.
Have a nice evening! :-)
------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
