Can anyone explain what this means? It occurs when I issue what should
be a straightforward insert:

  INSERT INTO resource_usage (resid,xmlid,xmltable)
     (SELECT resid,?,? FROM resource_usage WHERE xmlid=? AND xmltable=?)

The select returns 64 results, but the ibsert fails.

----------------------------------------------------------------------
 John English              | mailto:[email protected]
 Senior Lecturer           | http://www.it.bton.ac.uk/staff/je
 School of Computing & MIS | "Those who don't know their history
 University of Brighton    |  are condemned to relive it" (Santayana)
----------------------------------------------------------------------

Reply via email to