Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Writing database strings to a file
Fri, May 1 2009 4:58 PMPermanent Link

"Malcolm"
I have a table with a column of type string and I wish to select
quite a lot of these strings and write them to a file for processing
by another app.

I tried using a query to select a range and then use
Query.ExportTable(..).
But the strings include some double-quotes and the export,
unhelpfully in this case, doubles-up all those double-quotes then
sticks a further one at the start and end of each string.   Surprised

Is there a convenient way I am missing to write these strings
unaltered (one string per row in the output file)?

--
Wed, May 6 2009 11:53 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Malcolm,

<< Is there a convenient way I am missing to write these strings unaltered
(one string per row in the output file)? >>

The only way to do so, outside of the export, would be to write out the file
in code by simply looping through the table and using the TField.AsString
method to write out each field unaltered.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, May 6 2009 2:49 PMPermanent Link

"Malcolm"
Tim Young [Elevate Software] wrote:

> The only way to do so, outside of the export, would be to write out
> the file in code by simply looping through the table and using the
> TField.AsString method to write out each field unaltered.

Thanks Tim.  The long silence told me there was nothing obvious, so I
fell back on that process.  Surprised

--
Image