Timestamp Problem

[naitsabes]

Hi, I have a very wierd problem.

I have a recordset with a timestamp datatype. (adodb, mdac 2.8, vb6)
It my form(client) I have a function that calls to an activex dll function that in turn calls a stored procedure to insert the record into the database table.

The timestamp value should be null or empty , I checked the value just before I call the function from the client and it is empty, as soon as it gets to the function in the dll it is no longer empty. I can't see the value but I know that it is not null.

The crazy think is that if I load my client project and dll project and run them within the same IDE then the value doesn't change.

This has really thrown me for a loop...any ideas?

Thanks.
...

[RhinoBull]

One thing could be that you "actual" (compiled) dll and project dll might not be in sync. So, recompile it first to see if that helps first.

[naitsabes]

I tried the recompile, I even recopiled everything and promoted the dll to the MTS server and I still get the error??? Crazy Isn't it

[RhinoBull]

Not really ... Sinse you have multiple components (front end, dll, stoed proc) involved - it might be difficult to determine which piece is the bad guy, so you might need to step through your code and debug it thoroughly. It could be anything including some process not having enough time to finish but some other has already started (compiled app runs much faster in most cases).

Good luck.

[naitsabes]

Ok, I'll do some in depth debugging to see what I can find..

Thanks
...