UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Function, Any Versions    
 
   
duggie
post Oct 25 2017, 11:58 AM
Post#1



Posts: 405
Joined: 14-October 12



Came across someone's db and saw this query:

CODE
dbo.getproduct(apples, pears)


Can someone tell what is getproduct? Is it the name of a table or a function?

Thanks
Go to the top of the page
 
GroverParkGeorge
post Oct 25 2017, 12:03 PM
Post#2


UA Admin
Posts: 31,196
Joined: 20-June 02
From: Newcastle, WA


Probably a function or stored procedure, but it's kind of hard to guess.

Is that the entire SQL string in the query? Is it a pass thru?

--------------------
Go to the top of the page
 
duggie
post Oct 25 2017, 01:12 PM
Post#3



Posts: 405
Joined: 14-October 12



No, there was a bit more code but I thought it was a table at first.

BTW, is it possible to "step into" SQL code, like one does in VBA?
Go to the top of the page
 
GroverParkGeorge
post Oct 25 2017, 01:25 PM
Post#4


UA Admin
Posts: 31,196
Joined: 20-June 02
From: Newcastle, WA


No, you can't step thru SQL.

Is this in a pass-thru query?

What is the ENTIRE SQL in this query?

--------------------
Go to the top of the page
 
PhilS
post Oct 25 2017, 01:50 PM
Post#5



Posts: 404
Joined: 26-May 15
From: The middle of Germany


QUOTE
No, you can't step thru SQL.

Well, as we're talking TSQL here, you absolutely can!

You need SQL Server Management Studio and you need to connect using either Named Pipes or Shared Memory.

--------------------
Go to the top of the page
 
GroverParkGeorge
post Oct 25 2017, 06:28 PM
Post#6


UA Admin
Posts: 31,196
Joined: 20-June 02
From: Newcastle, WA


Okay, so if you want to step out of Access to do it.

I should have specified the context.

--------------------
Go to the top of the page
 
duggie
post Oct 26 2017, 05:54 AM
Post#7



Posts: 405
Joined: 14-October 12



Afraid don't have rest of the code.

What is Named Pipes or Shared Memory?

How do I get to that?
Go to the top of the page
 
GroverParkGeorge
post Oct 26 2017, 06:18 AM
Post#8


UA Admin
Posts: 31,196
Joined: 20-June 02
From: Newcastle, WA


I'm sorry, I thought you had the accdb in which you found this line. Where in that accdb is it?

There are three (or possibly four) ways to communicate with SQL Server:

Attached File  Protocols.png ( 19.74K )Number of downloads: 0


Most of the time, you'll use TCP/IP

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    12th December 2017 - 07:11 AM