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

["the dragon" <ceprn@hotmail.com>]

You're welcome.  I am surprised, however, that putting the on-break on 
multiple lines would cause an issue; I've done that many times in the past 
for readability without any issues.  Although, I'm not ceertain I've ever 
tried it with dynamic columns...

peace,
clark 'the dragon' willis



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----

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')
----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