Ask a questionAsk a question
 

Answermultiuser function

  • Thursday, November 05, 2009 1:19 PMLarry_Nuñez Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     

    to allow mutiuser in fox pro 9.0 I must:
    1- Set exclusive off (in main program)
    2- Buffer tables in dataenvironment to 5

    this is all I did and it worked. now to record to a table, before the update command I change the table´s buffer to 1 and it worked. Am I doing this correctly? Will this bring any problems later in usage. I use the insert and update commands, I don´t use tablupdate.

Answers

  • Thursday, November 05, 2009 2:03 PMCetinBasozMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    No. Use tableupdate(). Do not switch buffering to 1 (which means removing it). Having table buffering doesn't prevent using insert/update commands.

    And you forgot the most important:
    -Private datasession (not directly related to multiuser but in a single VFP session you can act as a multiuser)
    -"set exclusive off" in DE.BeforeOpentables or  form load or init


All Replies

  • Wednesday, November 04, 2009 5:44 PMLarry_Nuñez Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    How do I record data to a table that´s buffered to optimistic locking. I can´t record with this property. I´m trying to convert my app to  multiuser.
  • Wednesday, November 04, 2009 6:13 PMdni Users MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     
    Again, use tableupdate().
    dni
  • Thursday, November 05, 2009 2:03 PMCetinBasozMVPUsers MedalsUsers MedalsUsers MedalsUsers MedalsUsers Medals
     Answer
    No. Use tableupdate(). Do not switch buffering to 1 (which means removing it). Having table buffering doesn't prevent using insert/update commands.

    And you forgot the most important:
    -Private datasession (not directly related to multiuser but in a single VFP session you can act as a multiuser)
    -"set exclusive off" in DE.BeforeOpentables or  form load or init