Stephen, The conflicts are dependent on the settings for the view. Maybe if you posted the view source code (Show SQL in the View Designer). Another suggestion is to use the SQL Profiler to see what VFP is sending back to SQL Server.
Rick White Light Computing, Inc. www.whitelightcomputing.com www.rickschummer.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Wolfe, Stephen S YA-02 6 MDSS/SGSI Sent: Monday, April 16, 2007 10:44 AM To: [EMAIL PROTECTED] Subject: VFP8: Update Conflict What are the 'valid' reasons for getting an update conflict when you are using a remote view to a MSSQL table back end? The view carves out selected records and computed values from a single table. Activity on the table is typically very, very low. Like maybe a few transactions per second would be considered a heated exchange. The norm is more like a transaction per 10 - 15 seconds. I need some troubleshooting ideas. TIA v/r //SIGNED// Stephen S. Wolfe, YA2, DAF 6th MDG Data Services Manager 6th MDG Information System Security Officer Comm (813) 827-9994 DSN 651-9994 [excessive quoting removed by server] _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
