TimeStamp Problem using ADO Control

[Bob]

Hi all,

I am trying to pass a timestamp value to an ADO field and
I am getting the following error :
-2147217887
Multiple step operation generated errors. Check each
status value.

I aasign the value as :

..Fields("FPTMSTMP") = s_timestamp1

If i assign s_timestamp1 = 2003-11-25 2:24:18 PM, It
accepts the value.
However, if i assign the value as s_timestamp1 = 2003-11-
25-14.41.57.000000 , it gives the error .

Can anyone help me out in this.

Thanking in advance ,

Bob

[One Handed Man]

1.) You may be trying to pass a String to a Numeric field.
2.) You may be exceeding the width of a field.

Look at your data in detail. Perhaps try a small amount of data to work with
to see if you still get the error.

Regards - OHM

--------------------------------------------

Bob wrote:

Hi all,

I am trying to pass a timestamp value to an ADO field and
I am getting the following error :
-2147217887
Multiple step operation generated errors. Check each
status value.

I aasign the value as :

.Fields("FPTMSTMP") = s_timestamp1

If i assign s_timestamp1 = 2003-11-25 2:24:18 PM, It
accepts the value.
However, if i assign the value as s_timestamp1 = 2003-11-
25-14.41.57.000000 , it gives the error .

Can anyone help me out in this.

Thanking in advance ,

Bob