Hi Chuck

I am showing resulting cursor after sqlexec() from SQL 7 in the grid. I make cursor updatable with CursorsetProp() etc...

In the grid I get Datetime format what I have to change in Date format. If I set control for field with Todd() function I get date format, but control becomes read only. It is not possibile to change the date field in the grid.

I have found the solution for Views - DbsetProp("MyView.Date","Field","Datatype","D") in the book SQL Server and VFP where you are one of the autors.

If there is no so simple solution as for Views I am goung to use Views instead SPT.


Thanks in advance

Toni