I have MicrosoftR Visual FoxProR OLE DB Provider 9.0.0.3504 installed. In the visual database tool, when I run "SELECT DATE() FROM MYTABLE", visual studio will give me the follow error:
Error in SELECT clause: expression near ')'.
Error in SELECT clause: expression near 'FROM'.
Missing FROM clause.
Unable to parse query text.
However in visual studio 2003 on another machine, everything works fine.
I tried to reinstall visual studio 2005 and the fox pro ole db provider many times. I still get the errors. Also, I remember it works on my friend's visual studio 2005.
Can someone give me some help to fix this
Thanks in advance.
Also, "Verify SQL Syntax" returns "This command is not supported by this provider".
Visual Studio 2005 Database tools problem with Fox pro 9.0 sp1 ole db provider
Jkumar
Hi Cindy,
..but when you try to use it with the show criteria pane, the DATE() field won't show up there, and the error is kind of annoying everything you try to run a query in visual database tool.
Thanks.
rusty_dev
Hi Coder,
When I type "Select Date() From MyTable" in the SQL Panel of the query editor I get the error mesage box just like you got. When I hit the OK button the query is rewritten as
SELECT DATE ()
FROM MyTable
and then the appropriate data shows in the results pane.