1. Murray Sobol
  2. PowerBuilder
  3. Monday, 5 February 2018 20:05 PM UTC

In Appeon 12.7 (or later) do you plan to support table-valued functions?

We (and I suppose several other customers) could make great use of this functionality; having the ability to essentially pass parameters to a view would make our SQL retrieval times much faster.

We develop using SQL Server and Oracle databases.

Comments please.

 

 

Roland Smith Accepted Answer Pending Moderation
  1. Tuesday, 6 February 2018 13:20 PM UTC
  2. PowerBuilder
  3. # 1

A table valued function is a user defined function that returns a result set (similar to many stored procedures) but can be used in a query as if it were a table.

You wouldn't be calling them directly from PowerBuilder.

Comment
There are no comments made yet.
Marco Meoni Accepted Answer Pending Moderation
  1. Tuesday, 6 February 2018 07:25 AM UTC
  2. PowerBuilder
  3. # 2

Hello Murray,

as Chris pointed out, you're asking for stored funcs/procs support.

In PB you can just declare

FUNCTION  DBfunctionName(args) RPCFUNC
SUBROUTINE DBprocedureName(args) RPCFUNC

​And invoke in your code

returnValue = sqlca.DBfunctionName(args).

Look for "RPCFUNC" keyword in the PB help and you will get plenty of examples.

HTH.
Cheers,

.m

 

Comment
There are no comments made yet.
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 5 February 2018 21:14 PM UTC
  2. PowerBuilder
  3. # 3

Hi Murray;

  Do mean basically what I call a  "Stored Function"?

Regards ... Chris

Comment
  1. Murray Sobol
  2. Monday, 5 February 2018 21:15 PM UTC
I think so  if we are both talking about the same thing...

  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.