Hi,
I have an old database which store a employee working hour in string format. I need to use VFP to generate report base on this database. The problem is, I can't get use of CTOD() in remote view. I tried to import all data from this remote view before query and generate report from it. However, It really really slow down my performance. It take about 1 minute or more to import only 40,000 records!!!!
Any ideas to optimise the query?

Thank you