Remote View runs its query on the SQL Server. SQL Server do not have such function as CTOD(). Use SQL Server functions to convert dates to character string, using convert(,) function, for example. There are many equivalent functions on SQL Server for VFP functions, but they just have different names and syntax.
> 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
Vlad Grynchyshyn, Project Manager, MCP vgryn@yahoo.com ICQ #10709245 The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.