> Can't recall who recommended gnue for my simple
> invoice system, but thanks :-)
Quite likely was me, as I'm biased on such things.
> Took a couple days break from the install problems,
> and within a hour or two today, I have most of it working.
> This is neat stuff.
Cool. If you got it installed thats WAY harder than writing applications. :)
> Anyway, my first question:
I am cc'ing this to the GNUe list as its good for the list to hear such things.
> I have created a stupid simple database with a couple
> tables. Se below:
> -----------------------------------------------
> DROP TABLE IF EXISTS invoice;
> CREATE TABLE invoice (
> invoice_id int(10) NOT NULL AUTO_INCREMENT,
> name varchar(30),
> company_name varchar(40),
> address varchar(80),
> city varchar (40),
> state varchar (40),
> postal varchar(20),
> phone varchar(30),
> email varchar(80),
> comments text,
> PRIMARY KEY (invoice_id)
> );
> DROP TABLE IF EXISTS invoice_details;
> CREATE TABLE invoice_details (
> invoice_details_id int(10) NOT NULL AUTO_INCREMENT,
> invoice_id int(10),
> description varchar(200),
> qty int(3),
> cost varchar(10),
> total varchar(10),
> PRIMARY KEY (invoice_details_id)
> );
> -------------------------------------------------
> Running the advanced wizard in gfdesigner allows me to call
> the master/detail tables and link them up. Everything works
> the way I expect except that the detail table does not get
> the master key (invoice_id). In case I haven't stated it,
> this is linked to a MySQL database (3.23.49). The entries
> in the invoice_details table for invoice_id are all NULL.
> Anyone?
We have a magic function to do that, I suppose we should put it in the wizard as well. Jamest any comments? I will look to post a sample ASAP in cvs that shows how to do this.
> Second question, can someone point in a a direction to run
> a report against this data. gnue/forms is already installed,
> but I haven't firgured out this process yet?
gnue/reports/ - Update CVS regularly for reports as we have been pounding on it hard last week or so and I only expect that to continue. :)
Derek Neighbors
GNU Enterprise
http://www.gnuenterprise.org
(text/plain)