When will a view ( joined tables! ) be updateable?
Posted in 1999
Topics: SQL Development & Query Writing
Hi ! Subject says it. Yours Klaus PS: a couple of months ago there was a 'wish list' on the listserver
Klaus Weitzer wrote: > > Hi ! > Subject says it. > > Yours > Klaus > > PS: a couple of months ago there was a 'wish list' on the listserver What version are you using? I believe that that was added to 7.30, but I may have my feature sets mixed up and it is in 7.31 due in mid Feb. Art S. Kagel
Klaus Weitzer wrote: > > Hi ! > Subject says it. > > Yours > Klaus > > PS: a couple of months ago there was a 'wish list' on the listserver You can sometimes rearrange the joined view query to have a subquery in the where clause instead of the join. This is then updateable. I have a suspicion that the manuals (Tutorial?) have something about this. This might tide you over until the feature is added (see Art's response). -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 -- If all else fails, read the instructions and the release notes. Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/