Predmet:Re: stored procedure Kako?
Tvoj Query sto si naveo ima jos procedura koje nisi dao pa sam ja napravio jednu srored proceduru kao primjer pa se nadam da ce ti pomoci da napravis ono sto zelis.
Ovu tored proceduru postavi u svoju bazu MsSQL.
PreuzmiIzvorni kôd (SQL):CREATE PROCEDURE ArtikalBR @ID INT
AS
SELECT
ID_Artikal,
Artikal_Sifra,
Artikal_Ime,
Artikal_Prodazna_cena,
Artikal_DDV,
(Artikal_Prodazna_cena*Artikal_DDV) AS CENA
FROM tblArtikli
WHERE ID_Artikal=@id
GO
Ovo ide u VB.
PreuzmiIzvorni kôd (Visual Basic):Function RSArtikla(IDArt As Integer)
Dim Kon As New ADODB.Connection
Dim Rs As New ADODB.Recordset
Dim SQL As String
Dim strUserName As String, strPassWord As String, strDatabase As String, strServer As String
strUserName = "Ime"
strPassWord = "Sifra"
strDatabase = "Baza"
strServer = "ImeTvogServera"
Kon.CursorLocation = adUseClient
Kon.Open "Provider=MSDASQL; DRIVER=Sql Server; SERVER=" & strServer & "; DATABASE=" _
& strDatabase & "; UID=" & strUserName & "; PWD=" & strPassWord & ";"
Set Rs = New ADODB.Recordset
SQL = "EXECUTE ArtikalBR " & IDArt
Rs.Open SQL, Kon, adOpenKeyset
MsgBox Rs!Artikal_Ime & "----" & Rs!CENA
Kon.Close
End Function
Podrska samo putem foruma, jer samo tako i ostali imaju koristi od toga.