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”

 

I wrote a test procedure that accepts an input varchar, changes the string to initial caps and returns the output string.  This works great.  But now I want to create another stored procedure that contains a FOR SELECT on the table I want to update.  However reading this page: http://ibexpert.net/ibe/index.php?n=Doc.FORSELECTINTODO  mentions this caution statement:

 

Caution! If the value of a PSQL variable that is used in the SELECT statement changes during execution of the loop, the statement may (but will not always) be re-evaluated for the remaining rows.

 

To me, this means I should not create this procedure:

 

create procedure InitialCapsMyTable

as

begin

   for select a, b from MyTable

     into :aa, :bb

   do

   begin

     :aa = initial_caps_proc( :aa );

     :bb = initial_caps_proc( :bb );

   end

end

 

Questions

1)      Am I correct that the caution mentioned above applies my example?

2)      Is there a better way to accomplish changing a column (all records) to initial caps?

 

I’m using FB1.5, 

 

Daniel