>>What is the syntax to change a field type from DateTime to Date? I receive a cursor from call to SQL Server and want to change the field type to D(date). I tried to use DBSETPROP() but it requires a database so I am trying to see how to use the CURSORSETPROP() but can't seem to find the right syntax.
>
>It cannot be done with CURSORSETPROP().
So the only way to do it is to create a procedure to copy the fields to another cursor (or the "right" structure)?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
