Hey Fox Folx!
I have a Web Connect app (VFP8) that's been running fine for a while. It utilizes a DBC full of Remote Views connecting to a SQL Database. One of the views has the following syntax:
SELECT TOP 1 key_ FROM event ORDER BY key_ DESC
When I put in a new install of this, I have a routine that rebuilds the DBC from a table. When I put in my first one running on MSDE (instead of full blown SQL Server 2000), I get an error when I hit the 'CREATE VIEW' for this View (and one other View that uses the same 'SELECT TOP 1' syntax).
What gives? I have tried SPT on the machine and I always get a return of -1 when I try anything with SELECT TOP in it. Is this a known differnce between MSDE and SQL Server?
Thanks in advance!
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".