Subject Re: [firebird-support] for select stored procedure question
Author Woody
Post date 2013-10-10T15:42:54Z
 
Sent: Thursday, October 10, 2013 10:33 AM
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)