B4J Question RDC Database Access and Stored Functions

G

GuyBooth

Active Member
Licensed User
Longtime User
I have a database that, along with the data tables, contains a couple of stored functions. Access to these functions with VB6 was part of the cmd string - eg in the following, the stored function is sfArticle:
B4X: 
cmdSelectPerformers = "SELECT DISTINCT Performers,sfArticle(Performers) AS FPerformers FROM primarygroups ORDER BY FPerformers;"

Running this is B4J yields this error in the log:
B4X: 
java.sql.SQLSyntaxErrorException: (conn=511) FUNCTION sfArticle does not exist

Is there a way to access my stored functions?
 
Sort by date Sort by votes
K

keirS

Well-Known Member
Licensed User
Longtime User
GuyBooth said:
Exactly as shown in my first post. But it's not a procedure - it's a (stored) User Defined Function function.
Edit: Just looking into the link you have in your post ...
Click to expand...

Is this MS SQL Server? If so you have to specify the schema name for the function. So probably dbo.sfArticle by default.
 
Upvote 0
G

GuyBooth

Active Member
Licensed User
Longtime User
keirS said:
Is this MS SQL Server? If so you have to specify the schema name for the function. So probably dbo.sfArticle by default.
Click to expand...
No, it's MariaDB … but you pointed me in the right direction!
It works with very little change, and I was looking for solutions in all the wrong places!
My database is MariaDB running on a Synology NAS. The database name (schema) is "NAS1_MusicBase" and this statement works:
B4X: 
"SELECT DISTINCT Performers, NAS1_MusicBase.sfArticle(Performers) AS FPerformers FROM NAS1_MusicBase.primarygroups ORDER BY FPerformers;"

Thank you for your wisdom!
 
Upvote 0
K

keirS

Well-Known Member
Licensed User
Longtime User

Ah OK. It was the terminology that confused me. A UDF in MySQL/MariaDB is a global function usually written in C++. In SQL server a UDF is the equivalent of a stored function in MariaDB/MySQL.... Glad you got it sorted.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

M
  • Question
B4J Question [BANanoVue] Add component to NavDrawer [SOLVED]
Replies
7
Views
868
Mashiane
  • Question
B4J Question [ABMaterial] Before I place a New Component Request
Replies
5
Views
1K
alwaysbusy
  • Article
Android Code Snippet [B4X] [XUI] Accurate Text Measurement and Drawing
Replies
11
Views
16K
Erel
  • Article
B4J Code Snippet JavaScript Replace with RegEx pattern
Replies
2
Views
3K
rwblinn
  • Question
B4J Question unable to stuff clipboard
Replies
6
Views
2K
drgottjr
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…