Selecting a record that is updating
Mike __________________________________Mike Lewis (Edinburgh, Scotland)Visual Fox Pro articles, tips, training, consultancy Thanks for all the help everybody. Apart from that, it looks like you're on the right track.
I ended up going a different direction to get the same results. Mike __________________________________Mike Lewis (Edinburgh, Scotland)Visual Fox Pro articles, tips, training, consultancy Bad form to use CLOSE TABLES so willy-nilly, too.
Just filter the count directly: The literal answer is "yes".
But since it's unclear to me what you're actually after, I can't go any further than that.
I'm writing this for an existing foxpro program where people are in these tables all the time so my thought process was to close them as soon as I was done with them. Even better SET EXCLUSIVE OFF, then all USE will use shared.Is there a setting a I can turn on that will prevent the tables from being locked or allow me to select the records within the table if they have them open? And last not least, if you do SQL, tables are opened, you don't need to do that.The default setting of the VFP IDE for the EXCLUSIVE setting ON is to open data exclusive, but it's not the default for an EXE.Perhaps with more clarity we can assist you better.Good Luck, JRB-Bldr I expected the original SQL being a single complexer Update SQL.