It's an internal procedure. I fixed my message file version issue and the error simply says:
SQL error code = -804 Function unknown initial_caps_proc However this works: select * from initial_caps_proc( 'testing my test' ) From: [email protected] [mailto:[email protected]] On Behalf Of Woody Sent: Thursday, October 10, 2013 10:59 AM To: [email protected] Subject: Re: [firebird-support] for select stored procedure question Is initial_caps_proc an external function or an internal procedure? If it's an external function you need to make sure you declared it to the database and the DLL is in the UDF directory. It also looks like you might have a mismatched help file for FB since it's showing you an @1 where something else should be. Woody (TMW) -------------------------------------------------- From: "Raith,Daniel" <[email protected]> Sent: Thursday, October 10, 2013 10:52 AM To: <[email protected]> Subject: RE: [firebird-support] for select stored procedure question > I tried using my stored procedure in an update statement like so: > > update MyTable > set ColumnA = initial_caps_proc( ColumnA ) > > but I get an error saying "function unknown. @1" > > Daniel > > From: [email protected] > [mailto:[email protected]] On Behalf Of Woody > Sent: Thursday, October 10, 2013 10:43 AM > To: [email protected] > Subject: Re: [firebird-support] for select stored procedure question > > > > From: Raith,Daniel<mailto:[email protected]> > Sent: Thursday, October 10, 2013 10:33 AM > To: > [email protected]<mailto:[email protected]> > Subject: [firebird-support] for select stored procedure question > > I want to write a stored procedure that updates two columns (all records) > in a table to initial caps or camel case. > > For example: "testing a test" -> "Testing A Test" > > > > Why not just run a query to update the values if you only need to do it > once? > > Update MyTable set column_A = initial_caps_proc(column_A), column_B = > initial_caps_proc(column_B) > > > if you really need a stored procedure that just returns the values and > doesn't update them, then simply use this in the procedure: > > for select initial_caps_proc(column_A), initial_caps_proc(column_B) from > myTable > into :aa, :bb do > suspend; > > > Woody (TMW) > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Resources item > on the main (top) menu. Try Knowledgebase and FAQ links ! > > Also search the knowledgebases at http://www.ibphoenix.com > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > Yahoo! Groups Links > > > [Non-text portions of this message have been removed]
