RE: [sqr-users] quickest way to count how many commas are in a string

["Overcashier, Patricia" <Patricia.Overcashier@aam.com>]

You are right.  After actually pulling it off, I found an easier way.  
But this is what I was originally trying to do.

I was going against the user_ind_columns to get the columns of the
primary key to use in a select statement.  
I get the tablename from my audit table (select recname from psaudit),
but want to display the primary keys on a report.

Begin-select
Column_name
Table_name
   $table_name = &table_name
   $column1 = &column_name
From user_ind_columns
Where index_name = 'PS_'||$recname
Order by column_position
End-select

Then I use the column names as a dynamic select

Begin-select
[$column1]
[$column2]
From 
[$table_name]
End-select


There were a lot more twists and turns to get through this, but since
then I have recoded and simplified it greatly.  

Thanks all for your help.

-----Original Message-----
From: sqr-users-bounces+patricia.overcashier=aam.com@sqrug.org
[mailto:sqr-users-bounces+patricia.overcashier=aam.com@sqrug.org] On
Behalf Of George Jansen
Sent: Friday, October 13, 2006 10:28 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] quickest way to count how many commas are in a
string

It seems to me that the route SQL -> string -> SQL is a bit cumbersome.
You have a dynamic select statement, but what are you selecting?

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users