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.