Welcome, Guest
Username: Password: Remember me

TOPIC: ### is not a valid BCD value

### is not a valid BCD value 1 year 3 months ago #18271

running a simple query, on Data page i see the results.
Sometimes i've got the error "### is not a valid BCD value" on a msgbox alert (See attach.)
It's impossible to get out or close the alert box.
Closing alert box, a new alert repeat himself for ever (sometimes, changing mouse position, changes the number before alert)
In this forum and on internet there is no one with the same error on database browser portable.
I'm from Italy,
Attachments:

Please Log in or Create an account to join the conversation.

### is not a valid BCD value 1 year 3 months ago #18272

We need somehow to reproduce the problem in the office.

Can you provide us with table creation scripts and the select sql please
The following user(s) said Thank You: fabiocas

Please Log in or Create an account to join the conversation.

### is not a valid BCD value 1 year 3 months ago #18273

this is the query
>>>>>>
Select
ATTDocRighe.CodArt As Articolo,
ATTDocRighe.CodCommessa As Commessa,
STDAnagrafiche.RagioneSociale As Nominativo,
ATTDocTeste.DataDocumento As DataDoc,
ATTDocTeste.NCPKm As OreCarr,
ATTDocTeste.NumeroDocumento As NumDoc,
ATTDocRighe.Descrizione As Descrizione,
0 As Ricavi,
0 As Costi,
ATTDocTeste.SegueFattura As SegueFatt,
ATTDocRighe.Qta As Qta,
ATTDocRighe.CostoUnitario As CostoComm,
MAGAnagraficaArticoli.CostoAcquisto * ((100 -
IsNull(MAGAnagraficaArticoli.PercSconto1Acq, 0)) / 100) As CostoAcq,
MAGAnagraficaArticoli.CostoStandard * ((100 -
IsNull(MAGAnagraficaArticoli.PercSconto1Acq, 0)) / 100) As CostoSta,
STDViewListiniArticoloAcquisti.Importo * ((100 -
IsNull(STDViewListiniArticoloAcquisti.PercSconto1, 0)) / 100) As CostoList,
ATTDocRighe.Chiusa As Chiusa,
MAGAnagraficaArticoli1.Descrizione As Carrello
From
((ATTDocRighe Left Outer Join
ATTDocTeste On ATTDocRighe.IdDoc = ATTDocTeste.IdDoc) Left Outer Join
MAGAnagraficaArticoli On ATTDocRighe.CodArt = MAGAnagraficaArticoli.CodArt)
Left Outer Join
STDViewListiniArticoloAcquisti On MAGAnagraficaArticoli.CodArt =
STDViewListiniArticoloAcquisti.CodArt Left Outer Join
STDAnagrafiche On ATTDocTeste.IdAnagrafica = STDAnagrafiche.IdAnagrafica
Inner Join
MAGAnagraficaArticoli MAGAnagraficaArticoli1 On ATTDocRighe.CodCommessa =
MAGAnagraficaArticoli1.CodArt
Where
ATTDocRighe.CodCommessa Is Not Null And
ATTDocRighe.CodCommessa <> '' And
ATTDocRighe.CodCommessa = 'STI516210007570' And
(ATTDocTeste.NumeroDocumento Like 'AL%' Or
ATTDocTeste.NumeroDocumento Like 'CE%' Or
ATTDocTeste.NumeroDocumento Like 'CG%' Or
ATTDocTeste.NumeroDocumento Like 'CL%' Or
ATTDocTeste.NumeroDocumento Like 'CO%' Or
ATTDocTeste.NumeroDocumento Like 'CS%' Or
ATTDocTeste.NumeroDocumento Like 'CT%' Or
ATTDocTeste.NumeroDocumento Like 'NP%') And
ATTDocTeste.TipoDocumento = 2 And
ATTDocRighe.TipoRiga <> 3
>>>>>>>
in attach query table in excel, exported from sql express
Attachments:

Please Log in or Create an account to join the conversation.

### is not a valid BCD value 1 year 3 months ago #18274

Thank you, can you also provide us with field types

Articolo ?
Commessa
Nominativo
DataDoc
OreCarr
NumDoc
Descrizione
Ricavi
Costi
SegueFatt
Qta
CostoComm
CostoAcq
CostoSta
CostoList
Chiusa
Carrello

Please Log in or Create an account to join the conversation.

### is not a valid BCD value 1 year 3 months ago #18296

THank you for your interest,


Articolo varchar
Commessa varchar
Nominativo varchar
DataDoc datetime
OreCarr int
NumDoc varchar
Descrizione varchar
Ricavi constant
Costi constant
SegueFatt bit
Qta float
CostoComm decimal
CostoAcq (calculate decimal * money)
CostoSta (calculate decimal * money)
CostoList (calculate decimal * money)
Chiusa bit
Carrello varchar

Thank you again

Please Log in or Create an account to join the conversation.

### is not a valid BCD value 1 year 3 months ago #18297

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7644
  • Karma: 33
  • Thank you received: 427
Can you try Database browser version 5.3.2.3 please
Mike

Please Log in or Create an account to join the conversation.

We have 115 guests and one member online