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,
unit)
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