[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Inderesting Postgres/LSMB issue?
- Subject: Re: Inderesting Postgres/LSMB issue?
- From: Chris Travers <..hidden..>
- Date: Wed, 8 Jul 2009 17:04:12 -0700
On Mon, Jul 6, 2009 at 7:09 AM, beamends <..hidden..>
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.