I'm maintaining a PB9 system.

A datastore needs to SaveAs Text.
However, the resulting text file has spaces between the columns
instead of Tabs (CHAR(9)). As a result the file is four times biggger
than it need be.

The identical code in PB11.5 produces an acceptable file with TABs.

Is there something I should or shouldn't be doing to influence the
result? The doco says to expect TABs.

lds_file.SAVEAS ( 'mytext.txt', Text!, FALSE )
where lds_file is a pfc n_ds datastore created by retrieving 4500
records from an MS_SQL database table.

TIA

Larry Peters

I've never heard of a bug in PB9 where the tab becomes a set of spaces. 
Sounds to me like you may be missing a trim trailing spaces db parameter 
(TrimSpaces).

-- Terry Dykstra (TeamSybase)
http://powerbuilder.codeXchange.sybase.com/
http://casexpress.sybase.com
http://my.isug.com/cgi-bin/1/c/submit_enhancement

"Larry Peters"  wrote in message 
news:o0e0j6p1h6g521vdkgqplnruc2j7r0fcfe@4ax.com...

I'm maintaining a PB9 system.

A datastore needs to SaveAs Text.
However, the resulting text file has spaces between the columns
instead of Tabs (CHAR(9)). As a result the file is four times biggger
than it need be.

The identical code in PB11.5 produces an acceptable file with TABs.

Is there something I should or shouldn't be doing to influence the
result? The doco says to expect TABs.

lds_file.SAVEAS ( 'mytext.txt', Text!, FALSE )
where lds_file is a pfc n_ds datastore created by retrieving 4500
records from an MS_SQL database table.

TIA

Larry Peters 

Hi Larry,

Is it possible the text editor your using to view the file is changing 
the tabs to spaces? I know Textpad has an option to do that so other 
text editors may as well. Just a thought.

hth,
Mark

On 1/14/2011 6:54 AM, Larry Peters wrote:
> I'm maintaining a PB9 system.
>
> A datastore needs to SaveAs Text.
> However, the resulting text file has spaces between the columns
> instead of Tabs (CHAR(9)). As a result the file is four times biggger
> than it need be.
>
> The identical code in PB11.5 produces an acceptable file with TABs.
>
> Is there something I should or shouldn't be doing to influence the
> result? The doco says to expect TABs.
>
> lds_file.SAVEAS ( 'mytext.txt', Text!, FALSE )
> where lds_file is a pfc n_ds datastore created by retrieving 4500
> records from an MS_SQL database table.
>
> TIA
>
> Larry Peters