Thanks Wayne !
The lack of empty date concept in SQLServer, is what I've mean writing about incompatibility. I try to find solution that I will can use also in my other appllications when I decide to port databases from VFP DBC to SQLServer. The solution has to require as little code changes as possible. My existing VFP databases has NOT NULL date type fields. It seems to me that entering NULL date values will call for code changes in many places and it is the reason why I'm looking for another solutions. I can replace field with "1900-01-01" values or NULL values with empty date after filling cursoradapter and I am looking for solution that let me to do it in possible best/quick way.
>It's not that they are incompatible, it's just that SQL Server has no concept of what an empty date is. You should make the tables accept nulls and program accordingly.
>
>
>>I have an almost completed application that uses SQLServer to store data and VFP8 cursoradapters to edit the data. I solved all problems with one exception - VFP and SQL Server date/datetime data types incompatibility.
>>VFP empty dates are converted to "1900-01-01" values while saving. When I refresh the cursor user can see "1900-01-01".
>>I can use NULL values on both sides (VFP and SQLServer) but it leads to additional more complicated VFP code ( ISNULL, NVL() etc... inside forms and reports methods).
>>For me the best way would be to convert SQL Server "1900-01-01" and NULL values to empty VFP dates and vice versa but I can find the good idea how to make it happen without hurting application performance and without writing too much additional code. All ideas are welcome.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only