RE: [sqr-users] Fwd: On-Break Help With Dynamic Columns

["Jessie Dickenson" <jmdickenson@rainbow-media.com>]

Thank you for your input. I removed one of the 2 left parans. But the solution 
came about when I put the entire on-break command in a single line. If you see 
my code earlier, I had the on-break command in multiple lines - This seems to 
cause a problem when using dynamic columns.

Thanks,
Jessie

>>> ceprn@hotmail.com 09/20/05 1:41 PM >>>
I don't have the time to think about the rest of it, but you have an extra 
left parenthesis in your on-error....
ON-ERROR=SQR_ERROR((1,'PROCEDURE_NAME')


PSA: Salary <> Slavery. If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul. Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

I work to live; I don't live to work.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent. Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

I have to construct a dynamic SQL where the Break Column can be either 
"Agency" or "Direct_Client" . So, I have set a column variable, 
$Break_Field_ID to store this information before calling the SQL.

My query looks like this:
BEGIN-SELECT ON-ERROR=SQR_ERROR((1,'PROCEDURE_NAME')
[$Break_Field_ID]       &Break_Field_ID=char () on-break level=1
                        before=Bef_FIELD_Change
                        after=Aft_FIELD_Change
                        save=$Prev_Break_Value
                        print=never
FROM
        MY_SCHEMA.TABLE_NAME

I get the following errors:
Error on line 806:
    (SQR 4008) Unknown function or variable in expression: print
if not isnull($Break_Field_ID)

Error on line 806:
    (SQR 4105) Placement parameter incorrect.
                  print=never

I have researched the archives and I do not find any article that helps me 
resolve this problem.

Thanks in advance for all the help that I would receive from you.

Thanks,
Jessie


_______________________________________________
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


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