>Hi, I´m programming in VPF for about a year. I have finished seven Single User Apps but now i´m working in my first multiuser app (it´s a stock and inventory system, it has been working fine on a single computer but now i have to make it work for six users, i have a DBC with four main tables and my server has win2k) I want to ask you for suggestions because i´m very confuse

Hi Juan,
There is a lot of extra things to consider when building your first client-serv er application. But since this application only has four tables and six users, the task of making it multi-user shouldnt be too hard. Your questions however are hard to answer without more specific details ...

> with the use of Datasessions, Transactions, Buffers, etc. What is the best
> way to do the job ?

There is a great book from Hentzenwerke that will guide through these few issues and some larger ones involved with building multiuser applications. The book is called The Fundamentals: Building Visual Studio Applications on a Visual FoxPro Foundation by Whil Hentzen ISBN ISBN: 0-9655093-5-4


in attempt to give you some answers:
> Datasessions, Transactions, Buffers, etc. What is the best
> way to do the job ?

Data session handling will probably only be important if your application will need to open the same table more than once. If you dont need to do this, then dont worry about data sessions and just use everything in the default data session.

Transactions could be very important to your application if your users do data entry that needs saved to multiple tables conditionally. What I mean by 'conditionally' is say your application "saves" data to three tables. If for some reason your TableUpdate() or Insert SQL fails on the last table, you probably dont want to store a partial save and update the other two tables... transactions make it easy to handle this.

Buffering will be a very important concept to understand, you need to review the VFP help text in detail. Plus there is some good information on the wiki, see http://fox.wikis.com/wc.dll?Wiki~CategoryDataBuffering

good luck!