Problem 3 could be causing problems 1 and . The issue is, what is causing problem 3. You should look at that first. I don't think it's a VFP problem. You should look at the Citrix and hardware configurations carefully. I don't have any experience with Citrix, so I can't offer any advice in that area.


>1. We are using Cirix server and 34 client all over country. People start getting message like record in use by another user (error 130 etc.)
>Duplicate key gets generated. and Saved even though primary key existed. Begin tran End Tran also applied. Used to do tablerevert and rollback incase such a situation arrived (uniqeness of index...)
>Browsing tables with such duplicate records (with Browse command) shows 1st record correctly for next record it blanks the PKfield and shows rest of the other fields data. most of the time it shows duplicate data.
>
>
>2. Some times data not getting saved. (Thesee are User's remarks) We are having just 300 thousand rows in tables.
>We recreated tables using Create Table and recreated indexes after removing duplicate records. then it started saving.
>With Begin Tran and EndTran (with buffered 5 tables and Views) it should save all data or None data!
>
>
>3. Record locking issues. We are not using explicit lock command. but we are traping it in our error routine. Some times it takes 15-20 minutes of time to save a data. Most of the times user terminates the application for this reason (remember we are on Citrix server. all the users are working on same data at a time from distance location in the country)
>
>
>Dear Craig can u suggest me good architacture to migrate to SQL7.
>
>What are the issues I am looking at.
>
>Thanks Craig
>
>Diptesh
>Ps: Your KB articles are very useful. I have read and Used it b4.