I have a program that uses Paradox as the db. I must make it compatible so that it also runs on Sql Server. Everything looks fine except I have a problem with my date and time fields. Paradox only has Tdate and Ttime fields and Sql Sever only have Tdatetime fields. I use persistent fields on my table component. Delphi gives me an error 'Incompatible field types'. I understand why, but I don't know how to fix this. I tried using setfieldtype, but it only works for tblob fields.
Does anybody have any idea how I can get around this problem?
Thanx
Does anybody have any idea how I can get around this problem?
Thanx