#1  
Old 16th December 2018, 11:08 PM
Diniz
 
Posts: n/a
Default UPDATE error Mult Column and Blob Fields Tables and Samples

Hi Eivind

//UPDATE ERROR
SELECT REFERENCIA, DESCRICAO, UNIDADE, FOTO, INFORMACAO
INTO #Temp
FROM PRODUTOSB
WHERE CODIGO = 1;

UPDATE PRODUTOSA
SET REFERENCIA = (SELECT REFERENCIA FROM #Temp),
DESCRICAO = (SELECT DESCRICAO FROM #Temp),
UNIDADE = (SELECT UNIDADE FROM #Temp),
FOTO = (SELECT FOTO FROM #Temp),
INFORMACAO = (SELECT INFORMACAO FROM #Temp)
WHERE CODIGO = 1;



// INSERT (OK)
INSERT INTO PRODUTOSA SELECT * FROM PRODUTOSB WHERE CODIGO = 11;

thanks
Diniz

---
Este email foi escaneado pelo Avast antiv?rus.
https://www.avast.com/antivirus

Attached Files
File Type: rar Produtos.rar (183.8 KB, 0 views)


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
UPDATE multi column and UPDATE Blob Fields ERROR Diniz nexusdb.public.support.sql 3 18th December 2018 07:44 PM
FULL OUTTER JOIN Problem (Samples Tables) David Charron Binaries 0 10th February 2007 02:49 AM
LEFT JOIN wont work when tables has its blob fields filled David Charron nexusdb.public.support.sql 3 5th December 2006 08:49 AM
Using UPDATE in stored proc "Unkown column error" Dennis Esmonde-White nexusdb.public.support.sql 6 4th November 2005 05:23 PM
Beta 8 samples - type mismatch error Ole Willy Tuv nexusdb.public.support.adoprovider 1 20th February 2004 07:53 AM


All times are GMT +11. The time now is 12:01 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.