[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Long Description calls

Howdy Gang!
 
I'm using Maximo with Sqlbase.  Our workorder table has one column that has long description functionality out of the box and we have added long description functionality to three other columns in the table this week.  The information I have on this allows you to call the ldtext for each column by specifying the ldkey in combination with the ldownercol (column).  However, the report only prints out the ldtext for the DESCRIPTION column which has always had long description funcionality.  Below is part of the sqr code I am using.   In the procedure main I use a select statement as follows:
 
begin-procedure main
begin-select
wonum    &wonum
ldkey      &ldkey
etc....
end-select
end-procedure
 
Later in the code I call the list long description procedures:
 
begin-procedure list_ld_conditions
    position () @xxx1
begin-select
ld.ldkey
ld.ldtext    (+1,17,50) wrap 50 4
        from longdescription ld
        where ld.ldkey = &ldkey
        and ldownercol = 'WO1'         !This column has long description
        order by ldkey, ldlinenum       !functionality added
end-select
end-procedure
     
begin-procedure list_ld_jobassign
    position () @xxx2
begin-select
lld.ldkey
lld.ldtext    (+1,17,50) wrap 50 4
        from longdescription lld
        where lld.ldkey = &ldkey
        and ldownercol = 'DESCRIPTION'    !This column already had long
        order by ldkey, ldlinenum                !description functionality
end-select
end-procedure
 
begin-procedure list_ld_actwork
    position () @xxx3
begin-select
llld.ldkey
llld.ldtext    (+1,17,50) wrap 50 4
        from longdescription llld
        where llld.ldkey = &ldkey
        and ldownercol = 'WO8'            !This column had long description
        order by ldkey, ldlinenum          !functionality added now
end-select
end-procedure
 
 
 Can anyone help me out on this one?
 
 
Chuck L. King
Cryovac - Iowa Park, Tx.
BBS (940)691-9251
FAX (940)696-8119
www.wf.net/~clking
clking@wf.net