Preventing End of String Spaces in Appended Column in Table

[Uttam]

Hello,

Using ADO I have created a table and have also created fields.

To create fields, I have used the following:

..Columns.Appen d "Field_Name ", adWChar, 6

I load records into this created table including into this field.

I notice that if the value that I load into this field is less than
the full defined length of 6 chars, the balance is padded with spaces.

For example in this 6 length Char field, if I want to load the value
"APP1" then what really gets loaded is "APP1 " which has 2 spaces
padded at the end.

The value "APP1" is contained in another field and definitely has NO
padded spaces at the right. Even using something like:

!Field_Name = Trim(Another_fi eld)

does not help.

Any suggestions?

Thanks in advance.

Uttam

[Steve Jorgensen]

I think you need to specify varchar, not char.

On 8 Nov 2003 12:03:52 -0800, u0***@hotmail.c om (Uttam) wrote:

Hello,

Using ADO I have created a table and have also created fields.

To create fields, I have used the following:

.Columns.Appen d "Field_Name ", adWChar, 6

I load records into this created table including into this field.

I notice that if the value that I load into this field is less than
the full defined length of 6 chars, the balance is padded with spaces.

For example in this 6 length Char field, if I want to load the value
"APP1" then what really gets loaded is "APP1 " which has 2 spaces
padded at the end.

The value "APP1" is contained in another field and definitely has NO
padded spaces at the right. Even using something like:

!Field_Name = Trim(Another_fi eld)

does not help.

Any suggestions?

Thanks in advance.

Uttam

[Tom van Stiphout]

On 8 Nov 2003 12:03:52 -0800, u0***@hotmail.c om (Uttam) wrote:

Varchar data types don't offer this 'feature'.
-Tom.

Hello,

Using ADO I have created a table and have also created fields.

To create fields, I have used the following:

.Columns.Appen d "Field_Name ", adWChar, 6

I load records into this created table including into this field.

I notice that if the value that I load into this field is less than
the full defined length of 6 chars, the balance is padded with spaces.

For example in this 6 length Char field, if I want to load the value
"APP1" then what really gets loaded is "APP1 " which has 2 spaces
padded at the end.

The value "APP1" is contained in another field and definitely has NO
padded spaces at the right. Even using something like:

!Field_Name = Trim(Another_fi eld)

does not help.

Any suggestions?

Thanks in advance.

Uttam

[Uttam]

Sorry everyone - I guess I need to gain more confidence i my own
abilities!

I have found the solution myself and this is the way -

tbl.Columns.Ite m(0).Properties .Item(3).Value = True

The Item(0) refers to the field number in my table definition. For
example in my table field No 1 is the one where I want to have not
fixed length but length depending on the value of the field. Hence
Item(0).

Properties.item (3) refers to the "adColNulla ble" Property of the
column - that is Fixed length or actual length of the data. I have
simply set it to true.

Thanks to all those who tried to help.

Cheers!

Uttam
=============== ============

Tom van Stiphout <to*****@no.spa m.cox.net> wrote in message news:<96******* *************** **********@4ax. com>...

On 8 Nov 2003 12:03:52 -0800, u0***@hotmail.c om (Uttam) wrote:

Varchar data types don't offer this 'feature'.
-Tom.

Hello,

Using ADO I have created a table and have also created fields.

To create fields, I have used the following:

.Columns.Appen d "Field_Name ", adWChar, 6

I load records into this created table including into this field.

I notice that if the value that I load into this field is less than
the full defined length of 6 chars, the balance is padded with spaces.

For example in this 6 length Char field, if I want to load the value
"APP1" then what really gets loaded is "APP1 " which has 2 spaces
padded at the end.

The value "APP1" is contained in another field and definitely has NO
padded spaces at the right. Even using something like:

!Field_Name = Trim(Another_fi eld)

does not help.

Any suggestions?

Thanks in advance.

Uttam