#1  
Old 16th December 2018, 11:10 PM
Diniz
 
Posts: n/a
Default UPDATE multi column and UPDATE Blob Fields ERROR

HI

Considering 2 DATABASES
#1 JR_USOGERAL
#2 JR_MARILIA

and Fields Type

FOTO IS BLOB GRAPHIC
INFORMACAO IS BLOB MEMO

I Need INSERT and UPDATE Table from JR_USOGERAL to JR_MARILIA, keeping the
data synchronized

// INSERT (OK)
INSERT INTO JR_MARILIA.PRODUTOS SELECT * FROM CADPRODUTOS WHERE CODIGO =
:CODREPLICA;


// UPDATE
ERROR:
NexusDB: Query70402796: Query execution failed:
Unexpected exception object raised: [EInvalidCast] Invalid class typecast
[$3CA1/15521]

SELECT REFERENCIA, DESCRICAO, UNIDADE, FOTO, INFORMACAO
INTO #Temp
FROM JR_USOGERAL.CADPRODUTOS
WHERE CODIGO = 1;

UPDATE JR_MARILIA.PRODUTOS D
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;

Diniz
Brasil




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

  #2  
Old 16th December 2018, 11:29 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: UPDATE multi column and UPDATE Blob Fields ERROR

> NexusDB: Query70402796: Query execution failed:
> Unexpected exception object raised: [EInvalidCast] Invalid class
> typecast [$3CA1/15521]


As the message says, it's an unexpected exception. Can you provide
enough detail here to reproduce, or email us the tables and SQL

--
Eivind Bakkestuen [NDD]
  #3  
Old 17th December 2018, 12:04 AM
Diniz
 
Posts: n/a
Default Re: UPDATE multi column and UPDATE Blob Fields ERROR

see binaries

tks

Diniz

"Eivind Bakkestuen [NDD]" escreveu na not?cia da
mensagem:xn0lirzr14s6xd1000@news.nexusdb.com...

> NexusDB: Query70402796: Query execution failed:
> Unexpected exception object raised: [EInvalidCast] Invalid class
> typecast [$3CA1/15521]


As the message says, it's an unexpected exception. Can you provide
enough detail here to reproduce, or email us the tables and SQL

--
Eivind Bakkestuen [NDD]


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

  #4  
Old 18th December 2018, 08:44 PM
Eivind Bakkestuen [NDD]
 
Posts: n/a
Default Re: UPDATE multi column and UPDATE Blob Fields ERROR

> As the message says, it's an unexpected exception. Can you provide
> enough detail here to reproduce, or email us the tables and SQL


Thanks, the issue has been fixed for the next update.

--
Eivind Bakkestuen [NDD]


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
How to update with different values in each row of a single column? John Treder nexusdb.public.support.sql 6 8th April 2018 05:30 AM
Blob update Leslie nexusdb.public.support 5 16th December 2010 12:58 AM
Multi-Column update statement DanCroghan nexusdb.public.support.sql 0 7th December 2010 09:30 AM
Using UPDATE in stored proc "Unkown column error" Dennis Esmonde-White nexusdb.public.support.sql 6 4th November 2005 06:23 PM
Insert or Update an AutoInc Column Ken Randall nexusdb.public.support.sql 1 6th August 2005 03:09 AM


All times are GMT +11. The time now is 08:23 AM.


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