copy one row with computed fields to excel

[furei1976]

Hi All,

Can someone please advise me on how to copy one row with computed fields in a datawindow to excel?
I have tried rowscopy but it seems it did not work.
my code:
lds_extract.Rowscopy(1, lds_extract.RowCount(), Primary!, dw_1, 1, Primary!)

dw_1.saveas(fn,excel5!,true)

Please help.

thanks,
furei

 

[mbalent]

Is the Rowscopy failing or the saveas failing?

Matt


"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[furei1976]

the rowscopy does not work. the saveas will work but of course it will copy the entire datawindow content.

 

[mbalent]

This code you provided:
lds_extract.Rowscopy(1, lds_extract.RowCount(), Primary!, dw_1, 1, Primary!)
copies all rows from lds_extract to dw_1. I assume you have already filtered the data in lds_extract prior to the rowscopy so that it only contains one row, correct? Also, the datawindow objects for both lds_extract and dw_1 are the same, correct?

Matt


"Nature forges everything on the anvil of time"

http://www.anvil-of-time.com

 

[furei1976]

I did not do any filtering, I don't know what to filter. I am not that familiar with other built-in functions in PB. I am not that advanced user of PB.
I also tried OLE suggestion from Sybase

http://www.sybase.com/detail?id=47867,

it copies all the rows but not the computed fields.

Please suggest.