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 j...@brighton.ac.uk writes:
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=?)
I think we had a similar
On 12/07/2010 12:15 PM, John English wrote:
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,