NexusDB Newsgroups

NexusDB Newsgroups (http://www.nexusdb.com/forums/index.php)
-   nexusdb.public.support.sql (http://www.nexusdb.com/forums/forumdisplay.php?f=25)
-   -   UPDATE multi column and UPDATE Blob Fields ERROR (http://www.nexusdb.com/forums/showthread.php?t=20613)

Diniz 16th December 2018 11:10 PM

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


Eivind Bakkestuen [NDD] 16th December 2018 11:29 PM

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]

Diniz 17th December 2018 12:04 AM

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


Eivind Bakkestuen [NDD] 18th December 2018 08:44 PM

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]


All times are GMT +11. The time now is 07:14 AM.

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