Who Uses EXEC_SPF?

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
BLOMASKY
Posts: 1264
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Who Uses EXEC_SPF?

Post by BLOMASKY »

I use this in my applications to update attributes from a SQL Stored Procedure. There is a bug in the fact it does not return strings only numbers. Vlad is planning on making a change that will require code changes wherever it is currently being used.

Am I the only one who uses this a lot in their application?

Bruce
PointsWell
Posts: 1112
Joined: Tue Jan 24, 2017 5:51 am
Location: 'Stralya

Re: Who Uses EXEC_SPF?

Post by PointsWell »

I use it a little to compile dashboard data so I only ever get numbers back so would not have noticed this issue.

As a side note, what does SPF stand for? Stored Procedure Function? It automatically makes me think of Sun Protection Factor, but then SMH also means Sydney Morning Herald to me, so maybe I am too old to use the internets.
BLOMASKY
Posts: 1264
Joined: Wed Sep 30, 2015 10:08 pm
Location: Ocala FL

Re: Who Uses EXEC_SPF?

Post by BLOMASKY »

I "Assumes" SPF = Stored Procedure Function since the syntax is JUST like a SQL Function (with the = to the left of the function name, BUT it is a Stored procedure and has that syntax with the OUT attribute.

Bruce
Jaymer
Posts: 1944
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Re: Who Uses EXEC_SPF?

Post by Jaymer »

Bruce, I've got it scattered across several apps at multiple customers. Was glad that it got added.
Was a pain tho that it didn't do strings. Would have saved me some work.
Click Here to see a collection of my tips & hacks on this forum? Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply