On Wed, 2007-12-05 at 12:38 -0800, Chris Travers wrote: > > > > Ok, try taking a look at the actual tables. The fields are ints so it > is probably 1001, 4000, and 5000. > > In that case, the thing to do is UPDATE parts SET inventory_accno_id = > (select id from chart where accno = '1001') where inventory_accno_id = > '1001'; > > I would test on a copy of oyur db (either back up first or actually > copy the db into a new db, as in createdb -T ....) > > You can do the same for income_accno_id and expense_accno_id. > > Best Wishes, > Chris Travers >
Hi Chris, thanks for that - all ok now! Upwards and onwards... Cheers Richard > > ------------------------------------------------------------------------- > SF.Net email is sponsored by: The Future of Linux Business White Paper > from Novell. From the desktop to the data center, Linux is going > mainstream. Let it simplify your IT future. > http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users ------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
