>I am starting a project to develop some tools in VFP5 that will utilise tables concurrently used by a FPW2.6a system. Whilst I can access the tables as "free tables", I would like to base the new tools on Views based on the 2.6 tables. The 2.6 tables all have a Codebook 2.6 psuedo-primary key field cID c(9), which has ID's generated by Codebook's NetID() function. Therefore, there is a unique key value in the 2.6 table. Does anyone have any experience with this approach? I have read in the VFP help that views need a "primary key" in the source table to allow accurate/successfull updates. Will the 2.6 cID field value do? Any comments/tips/ideas very much appreciated.
Gary,
FWIW I've been using 2.6 tables in views for approx 18 mths with no problem, my tables vary from 30,000 to 1000,000+ records, I would be interested to know what sort of projects VFP is being used for in the UK, my current one is manging claims/repayments for a very large and complex liquidation (the biggest ever)
Regards
Pete Kane ( the other VFP programmer in the UK )
Regards,
Peter J. Kane
Pete