Hi all!
I'm using SQLServer, which, as you know, only has a DATETIME type. Now, I have a class which allows me to "bound" (doesn't really bound, it's just faking) itself to a datetime field but shows only the date portion - ie no time.
But the fun begins when I have to put the date field in a grid. The column/textbox has to be bound to the column, otherwise it won't display the data for that field. But now I get to see the time, which I don't want.
The closest we've got is to create a temporary cursor which is a copy of the actual data, plus an empty DATE field, close the original SQL result, and re-create the cursor with the original name, but with the data from the temp cursor. Problem is, we hit the 10 chars limit on field names with a CREATE CURSOR. We tried this way because the cursor name is important for the framework.
So we're fresh out of ideas here! Anyone has any pointers?
Thanks!
Sylvain Demers