Re: update syntax

Alex mclintock writes: > > Pretty please could someone tell me what's wrong with > this update statement. Thanks > > > update qprice, partmaster set qprice.qpmat = partmaster.curmat > where ( (qprice.qpson=27) AND (qprice.qpsonitem=103) > AND (qprice.qpqtyitem=1) > AND (partmaster.partnum='PC0651 A') > ) I don't know what you are trying to do but I was under the impression that you could only update one table using one update statement. The syntax UPDATE qprice, partmaster would not be permitted by my reading of the INFORMIX synatx diagrams. > > I am trying to copy a field out of the partmaster table (curmat) > into a field of the same type in qprice (qpmat). The two records > concerned have keys partnum (a string) and for qprice > three numbers: qpson, qpsonitem, and qpqtyitem. > > Do I have to build an IN clause to this update statement? > I am told by non Informix database people that the above > statement is ANSI and should work. > > Alex McLintock [also alex@arcfan.demon.co.uk] > editor No6 of the PGG in alt.galactic-guide Malcolm Weallans Online Database Consultancy 2 Arkley Court Maidenhead Berks SL6 2YR Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc