Hi
Could anyone let me know if I have done something wrong with the rule?
As when trying to update via ODBC the update fails. - But seems to work with
php though?
--
Postgresql 7.3.2
odbc up to and incl ver7.03.0201
1 view, joining 2 tables
(1 - many in this case- companies and contacts- 'orgref' and 'conref' being
the Primary keys)
--
View definition looks like:
SELECT contacts.conref, contacts.orgref, contacts.lastname,
organisations.lob
FROM (contacts
LEFT JOIN organisations ON ((contacts.orgref = organisations.orgref )));
Rule looks like:
UPDATE contacts SET lastname = new.lastname
WHERE (old.conref = contacts.conref ); UPDATE organisations SET lob =
new.lob
WHERE (old.orgref = organisations.orgref ); );
---
in this case trying to make changes to the lastname and lob fields.
Many thanks
_________________________________________________________________
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
