RE: [sqr-users] Trying to print LONG datatypes

["Benzenhafer, Dave" <DBenzenhafer@houston.deepwater.com>]

You were right. I had striped out a couple of unnecessary fields before I
emailed the query and forgot to strip the related tables.

What I found that worked was to do the query by itself and do the printing
process in another procedure instead of trying to do it all in the same
procedure. I guess when you have a long data type you need to query the data
first and then to the SQR printing.

Thanks for your assistance. This one had me stumped.
I have learned a lot from this mailing list. Thanks to All.

Dave Benzenhafer 


-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com] 
Sent: Monday, March 10, 2003 1:19 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] Trying to print LONG datatypes


Dave,

what happens when you run the select in sql*plus (outside of sqr) minus the 
sqr gibberish?  This almost looks like an issue with your select more than 
anything else - look at the values in the where clause.  Also, what is the 
purpose of adding the second table, EWM_TEXT_STEPS ts ?  It doesn't seem to 
add anything to the select criteria.

clark



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.

"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 tried the Substr and the error changed to "ORA-00932: inconsistent
datatypes".

I was using Distinct but it did not change anything when I removed it. There
is an example of the code. The Step Desc is the long data type. I have not
had to try to print this data type before.

Begin-Procedure File_desc

Begin-Select

t.ASSET_NO                   &ta_no   ( 1, 1)
substr(tst.STEP_DESC, 1, 250)  &t_desc  ( 3, 1, 85) Wrap 85 3 ON=<10> 
STRIP=/\^@<13>

    Next-listing Skiplines=1

>From EWM_TEXT            t,
      EWM_TEXT_STEPS      ts,
      EWM_TEXT_STEPS_TEXT tst

Where t.ASSET_NO = $p_corp_asset
And   t.FILE_NO  = $p_corp_asset_file
And   t.TEXT_NO  = ts.TEXT_NO
And   t.TEXT_NO  = tst.TEXT_NO

End-Select

End-Procedure File_desc


Dave Benzenhafer



_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail

_______________________________________________
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