Hi,

I'm getting information from SQL Server 2000 and of course the date is coming as datetime. Someone pointed out to me that I can use cursor adapter to convert the datetime to date and still keep it updatable.

This is my situation, I use SQL passthru to get a cursor which I make updatable. Now I want the datetimes to be converted to dates and STILL have the cursor be updatable.

If I select the cursor into another cursor adding another field as a date that will work for me but when I do this the new cursor is no longer updatable, is there a way to make this new cursor updatable?, otherwise will cursor adapter be able to accomplish this?

Thanks