You should check the error coming back (look at MESSAGE() or use AERROR(), for example) to help determine what the problem is.


>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!