Usersite
»
UserSite BA
»
Postavke
»
Program
»
Postake šifrantea, ltSetAccount
Rank: Datalab
Joined: 14/08/2009(UTC)
Posts: 1
Was thanked: 2 time(s) in 2 post(s)
|
Kada promijenim postavke šifranta, na VD 4*** mi ne prikazujem promijene koje sam napravio. Primjer:
Želim da mi prikaže samo konta sa brojem znamenak avecim od 5. Napravim to u sifrantu, ali mi na temeljnicama svjedno nudi cijeli kontni plan. Slike u prilogu.
Lp,
Damir
|
|
|
|
|
|
Rank: Datalab
Joined: 14/08/2009(UTC)
Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Workaround za ltSetAccount
Ne može se napraviti postoječim putem na nalogu za knjiženje, jer zbog upotreba više kontnih planova u programu zamjeni se where pogoj u exe-ju.
Riješenje je sledeče:
Napravi se view _vde_SetAccount5 (_ na početku znači, da nadogradnja neče izbrisati ovog), koji ima sledeči sql:
create view _vDE_SetAccount5
as Select * from tDE_SetAccount where LEN(acAcct)>=5
Onda se taj view upotrebi u ltSetAccount:
Select acAcct, acName, acPermitPost from _vDE_SetAccount5 order by acAcct
|
|
|
|
|
|
Usersite
»
UserSite BA
»
Postavke
»
Program
»
Postake šifrantea, ltSetAccount
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.NETThis page was generated in 0,481 seconds.