[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Inderesting Postgres/LSMB issue?

On Mon, Jul 6, 2009 at 7:09 AM, beamends <..hidden..> wrote:
Hi all,
I've been trying to create new rows from a C program. I can see the new
rows from phppgadmin ok, but the records are not visible form LSMB (yes,
I am using the right dbase!).

Any ideas? Am I missing some vital field or something?

The SQL is:

INSERT INTO parts (id, partnumber, lastcost, sellprice, drawing,
description, microfiche, income_accno_id, expense_accno_id,
VALUES (27791, '1013938', 1.86, 3.00, 'LAND ROVER800', 'PLUG - OIL
DRAIN', '800', 10023, 10075, '1')

The above "part" is created as a "service" because it has no inventory account associated with it.  You should be able to pull it up under Parts/Reports/Services.

For a part, you also need to set inventory_accno_id.

Best Wishes,
Chris Travers