Data Format Objects

[Flamer]

Basically i'm writing a program to take data from an sql server and export it to a text file.
But in between the fields there are spaces which I have not yet been able to remove.

More Importantly, when the field is negative the sign is put in front of the number. I need to take out the negative sign and insert a trailing negative, which would be a empty space if there was no negative.

So far looking around I believe I need a data format object. But I could be wrong.. does anyone know what i'm doing wrong.. if what I want is possible or not??

Thank you for your help
~Jay

[TheBao]

Flamer,

Data Format Object this the way to go.

Good luck

TheBao

[Flamer]

Where do i start with this though?

would you have any ideas or advice on how i can get this going?

I've been working all day on this.. any help would be much appreciated

Thank You
~Jay

[TheBao]

Flamer,

The StdDataFormat object allows formatting to be applied to data as it is read from and written to a database.

To use it add a reference to your project: Microsoft Data Formating Object Library.

Regards,
TheBao