Forum

Welcome Guest! To enable all features please try to register or login.
Bruto bilanca - problem ODJEL - Bruto bilanca - problem ODJEL
Options Go to last post Go to first unread
Previous Topic Next Topic
dadopmobis
#1 Posted: : 17 June 2013 15:39:05(UTC)
dadopmobis

Rank: Newbie

You have been a member since:: 17/06/2013(UTC)
Objave: 3

Thanks: 1 times
Pozdrav,

Na bulidu 6100 imam problem na Bruto bilanci, ako ne upišem odjel javlja grešku:
Cannot insert the values NULL into column 'acDept', table @tblDept;
column does not allow nulls. INSERT fails
MSSQL Error Code: 515

Ako upišem % u polje Odjel, onda ne javlja grešku ali mi otvara ispis 3 minute (što je sporo u odnosu do sada kako je radilo, jer je trebalo nekoliko sekundi da otvori ispis).
Ima li neka procedura za popravak?

HVALA!
igortest
#2 Posted: : 19 June 2013 03:35:21(UTC)
igortest

Rank: Member

You have been a member since:: 26/10/2011(UTC)
Objave: 3

Was thanked: 2 time(s) in 1 post(s)
Pozdrav,

u tablici knjiženje neki zapisi imaju null. To možete ispraviti ovim blokom kode:

exec pPA_SysSetConInfoRC 2, 1
update the_accttransitem set acDept = isnull(acDept, '') where acDept is null
exec pPA_SysSetConInfoRC 2, 0

Javite, dali če onda biti ok i brže.
 2 users thanked igortest for this useful post.
dadopmobis
#3 Posted: : 19 June 2013 10:52:21(UTC)
dadopmobis

Rank: Newbie

You have been a member since:: 17/06/2013(UTC)
Objave: 3

Thanks: 1 times
Pustila sam kod i OK je!!!

HVALA!
navotjer
#4 Posted: : 16 July 2013 12:07:40(UTC)
navotjer

Rank: Member

You have been a member since:: 03/03/2011(UTC)
Objave: 3
Man

Thanks: 2 times
Hvala!
WWW
protopliife
#5 Posted: : 13 January 2021 09:47:52(UTC)
Rank: Guest
Message was deleted by a Moderator. | Reason: Not specified
Rss Feed  Atom Feed
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Orange-Grey Theme Created by Ingo Herbote (WatchersNET.de)
Powered by YAF 1.9.6.1 Under DNN | YAF © 2003-2025, Yet Another Forum.NET
This page was generated in 0.543 seconds.