>I have a question...I'll try to strip this down to the bare essentials.
>
>Let's say there's a VFP application that runs against SQL Server.
>
>User 'A' goes into a module where promotion plans are entered. He filters on all promotion plans for a market for the 1st qtr 2002, and pulls back 25 plans. Let's say he does this at 8:00 AM.
>
>User 'B' goes into the same module, and does a filter such that he returns at least one of the 25 plans that user 'A' pulled back. He does this later in the morning.
>
>User 'A makes a change to one of the records around noon, and it is saved back to the SQL Server database. The record he changed is one of the records that User 'B' pulled down earlier...except that User 'B' now has an 'outdated' record. The possibility exists that User 'B' could make a change to the now 'outdated' record, and save it later in the day.
>
>I realize we could look at LASTUPDATE and examine each individual field for changes (synchronization logic), but that seems like it could be very complex.
>
>Our general strategy is to use Pass-through and stored procedures to bring data back to users as VFP cursors, and then Pass-through and triggers to update data everytime a user clicks SAVE. I guess the question is whether there is any way to make cursors returned from SPT 'dynamic' in nature, such that changes made by others are somehow 'refreshed' (and at this point, I think I'm really streching)...
>
>Any thoughts/ideas?
>
>TIA,
>Kevin