Is VFP9 Autocomplete table multi-user-shareable?

[wgcs]

Is VFP9 Autocomplete table multi-user-shareable?

That is, if I have two or more computers on a network running the same VFP application and accessing the same set of DBF's for data, can they both use the same AutoCompSource DBF at the same time?

Even if I test it and it works now, what if two users try to access the same field at the same time: does anyone know if it's designed to handle this? (I expect VFP to use the current settings for "SET EXCLUSIVE", "SET REPROCESS", etc, and to work if they are "OFF" and "anything but 0", but I'm just looking for reassurance)

- Bill

Get the best answers to your questions -- See FAQ481-4875.

 

[Juris]

Hi!
I try to run two form right now (one of them with Default DataSession) and another with Private DataSession.
In second I set AutoCompleteTable for text box and it's work. (I don't have network at this moment - I'm at Prague Devcon). Inputs that has been made in one form are available in another immediately


Juri Shutenko
Municipality of Maardu, Estonia

http://kodu.neti.ee/~juri4

http://www.hot.ee/jurisfox

 

[Mike Lewis]

Bill,

By default, all users will use the same AutoComp table, and this is definitely multi-user and sharable.

You have the option of specifying a different table for each user or group of users. You can do this through the text box's AutoCompTable property. If you do this, then it is of course up to you to what extent you make the table sharable.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)

 

[wgcs]

Thanks, Mike, for the reassurance. When testing the Auto Complete function, I never saw the AUTOCOMP.DBF table open in the SET window, and I wasn't sure about what settings VFP would use to access/index it (it certainly has to be open exclusively when it's first created and indexed...).

Since I need to place it in our application's data directory, I have examined it's structure (and it's index structure) and, for anyone interested, this code seems to successfully create it:

CREATE TABLE (gcDataPath+'AutoComp.DBF') ;
    ( Source C(20), Data C(254), Count I, ;
      Weight I, Created T, Updated T, User M )
INDEX ON UPPER(SOURCE+LEFT(DATA,30))+PADL(COUNT,8) TAG Data

Our app always has SET EXCLUSIVE OFF, so we should be fine setting the AutoCompTable property to:
=gcDataPath+'AutoComp.DBF'
So that whatever the gcDataPath is, it gets evaluated as the form & textboxes are created.


- Bill

Get the best answers to your questions -- See FAQ481-4875.

 

[Mike Lewis]

Bill,

Looks good. Let us know if you run into any problems.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My sites:
Visual FoxPro (www.ml-consult.demon.co.uk)
Crystal Reports (www.ml-crystal.com)