SQL Server using linked Server to Ellipse DB - Get WO Extended Text

[JasGrand]

Hello, I have a SQL Server Database for my application with a linked server to an Ellipse DB. I was wondering how i can get the extended text that shows up under a work order? I think it has something to do with the MSF096 - Standard Text table... not sure.

Let me know.

Thanks,



Jason

 

[PhantomPhil]

Work Order Description has one line on the Work Order Master record

select wo_desc from msf620
where dstrct_code = '0001'
and work_order = '00000002'

And extended description (zero or many lines) on Standard Text records

select * from msf096_std_volat
where std_text_code = 'WO'
and std_key like '000100000002'

std_key comprised of district code(4) + work order number(8)

Text is stored in std_volat_1, std_volat_2, std_volat_3, std_volat_4 and std_volat_5 - ie. there are 5 "lines" of text for every one msf096_std_volat record.