Re: Wartość zwracana przez procedurę SQL

Article View: pl.comp.bazy-danych.msaccess

Article #137747

Back to pl.comp.bazy-danych.msaccess Previous Next

#137747

From: siwy5
Date: Thu, 11 Mar 2021 13:05

40 lines
2602 bytes

środa, 10 marca 2021 o 11:59:45 UTC+1 siwy5 napisał(a):
> Witam 
> 
> Procedura wykonuje się poprawnie ale powinna mi zwrócić wartość (ilośćGodzin) Jak dostać się do zwracanej wartości? 
> 



> conn.Execute "TestProcSql 1, 2021, 2", ile 
> ile zawsze zwraca 1 
> 
> Pozdrawiam 
> Daniel



Coś się dogrzebałem - ale nie działa

Set cmd = New ADODB.Command
     cmd.ActiveConnection = cn
     cmd.CommandType = adCmdStoredProc
     cmd.CommandText = "proceduraSQL"		'proceduraSQL( @Id int , @Rok int , @Mc int )
     
     cmd.Parameters.Append cmd.CreateParameter("RETURN_VALUE", adInteger, adParamReturnValue, 0)
     cmd.Parameters.Append cmd.CreateParameter("Id", adInteger, adParamInput, 4, 1)
     cmd.Parameters.Append cmd.CreateParameter("Rok", adInteger, adParamInput, 4, 2021)
     cmd.Parameters.Append cmd.CreateParameter("Mc", adInteger, adParamInput, 4, 2)
      
   cmd.Execute Options:=adExecuteNoRecords
     
     
     msgbox cmd.Parameters("RETURN_VALUE")         'tu powinna zwrócić wartość ale zwraca 0
     msgbox cmd.Parameters("PrcId")



Pomoże ktoś?

Pozdrawiam
Daniel

Technical Details

Message-ID: <4c00d818-c1f8-40fc-a646-be8fab0fe11bn@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!3.eu.feeder.erje.net!feeder.erje.net!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!feeder1.feed.usenet.farm!feed.usenet.farm!tr2.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail

References: <588bae08-f9f2-42fa-8580-0e82f7db332bn@googlegroups.com>

Show Full Headers

Complete Article Headers

X-Received: by 2002:a0c:b611:: with SMTP id f17mr7564833qve.42.1615467906474; Thu, 11 Mar 2021 05:05:06 -0800 (PST)
X-Received: by 2002:a25:424f:: with SMTP id p76mr11650701yba.109.1615467906301; Thu, 11 Mar 2021 05:05:06 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!3.eu.feeder.erje.net!feeder.erje.net!newsfeed.xs4all.nl!newsfeed7.news.xs4all.nl!feeder1.feed.usenet.farm!feed.usenet.farm!tr2.eu1.usenetexpress.com!feeder.usenetexpress.com!tr1.iad1.usenetexpress.com!border1.nntp.dca1.giganews.com!nntp.giganews.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Thu, 11 Mar 2021 05:05:06 -0800 (PST)
In-Reply-To: <588bae08-f9f2-42fa-8580-0e82f7db332bn@googlegroups.com>
Injection-Info: google-groups.googlegroups.com; posting-host=78.11.115.26; posting-account=2H1BSAoAAADt5XeMBdV47foqa1rmVY0f
NNTP-Posting-Host: 78.11.115.26
References: <588bae08-f9f2-42fa-8580-0e82f7db332bn@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <4c00d818-c1f8-40fc-a646-be8fab0fe11bn@googlegroups.com>
Subject: Re: Wartość zwracana przez
 procedurę SQL
From: siwy5 <banasdaniel@poczta.onet.pl>
Injection-Date: Thu, 11 Mar 2021 13:05:06 +0000
Lines: 49
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message