Remote views on SQL Server 2005

I have a simple RemoteView on an SqlServer 2005 database.

Select id, ammount from table where month(data)=MONTH(GETDATE())

When I make an update on a single record it update all records for that id not only for that month.

What's wrong

Answer this question

Remote views on SQL Server 2005

Scott Herbert
You are not showing the update code.

I'm not clear. Is this a VFP remote view to a SQL Server 2005 DB

The query you showed only returns data for a certain month for all IDs. You are asking to update for one month for a single ID.

Something like this maybe

Update mytable set amount = nAmount where month(data) = nMonth and ID = cID
Remote views on SQL Server 2005

Answer this question