Usersite
»
UserSite SR
»
Podešavanja
»
Identi
»
Cena iz formule sa stored procedurom
Rank: Datalab
Joined: 14/08/2009(UTC) Posts: 1
Was thanked: 2 time(s) in 2 post(s)
|
Možeš li mi dati screenshot formula buldera koji vuče prosečnu nc iz stored procedure? Koje promenljive treba postaviti. Hvala unapred.
|
|
|
|
|
|
Rank: Datalab
Joined: 14/08/2009(UTC) Posts: 0
Was thanked: 1 time(s) in 1 post(s)
|
Promenljive se ne pojavljuju u formula bilderu. Sve radi procedura, odnosno procedura vraća cenu i rabat direktno u poziciju. U formuli stavljaš: exec _SREDNJA
Procedura:
ALTER procedure [dbo].[_SREDNJA] @cTip char(2) , @cCenRazred char(1) , @cKupec char(30), @cSkladisce char(30), @cIdent char(16), @cgValuta char(3), @dgDatum datetime , @nKolicina decimal(19, 6), @cKolicina char(1) as
set nocount on
declare @nVrniCena Float, @nVrniRabat Float
set @nVrniCena = 0 set @nVrniRabat = 0
select @nVrniCena = ZADNJACENA from zaloga where Ident = @cIdent and SKLADISCE = `Veleprodajno skladište`
select @nVrniCena, @nVrniRabat
Kao što vidiš ja trenutnu srednju nabavnu uzimam direktno iz tabele zaliha. Ovako može da se napiše šta god ti treba i uzme direktno iz baze.
|
|
|
|
|
|
Usersite
»
UserSite SR
»
Podešavanja
»
Identi
»
Cena iz formule sa stored procedurom
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-2026, Yet Another Forum.NETThis page was generated in 0.412 seconds.