Tableupdate() retuns T but acts as F - vfp8/SP1

Two users runing an VFP-app on workstation A and workstation B conected to a
LAN;
1 User A enter a textbox based on myView.myField
2 User B modifies the same textbox/field
2B User B leaves the TEXTBOX and it´s valid fires (lcSuccess =
tableupdate(1,.F.,myView) && returns T)
2C User B don´t leave the RECORD in myView
3 User A can´t see the modification made by B.

If user B leaves the record directly after the modifing everything works
just fine.

But if user B don´t leave the specific record - user A can´t see the
modification. And an updateconflikt occurs.

myView is optimistic rowbuffered, parameterized and contains one record
only. Exclusive is set off.

What´s wrong? Any ideas would be very appreciated.

Best reards
Christina

Marek
Sun Jan 09 16:31:17 CST 2005

Hi Christina,

You are updating the view too early ;)
Value from Textbox is written to the view field just AFTER the Valid event
returns .T.
Try to fire TABLEUPDATE(1,.F.,myView) in Textbox.LostFocus event.

Best regards,
Marek

U¿ytkownik "Ch Löfberg" <ch.lofberg@telia.com> napisa³ w wiadomo¶ci
news:4DADd.13578$d5.114591@newsb.telia.net...
> Two users runing an VFP-app on workstation A and workstation B conected to
> a
> LAN;
> 1 User A enter a textbox based on myView.myField
> 2 User B modifies the same textbox/field
> 2B User B leaves the TEXTBOX and it´s valid fires (lcSuccess =
> tableupdate(1,.F.,myView) && returns T)
> 2C User B don´t leave the RECORD in myView
> 3 User A can´t see the modification made by B.
>
> If user B leaves the record directly after the modifing everything works
> just fine.
>
> But if user B don´t leave the specific record - user A can´t see the
> modification. And an updateconflikt occurs.
>
> myView is optimistic rowbuffered, parameterized and contains one record
> only. Exclusive is set off.
>
> What´s wrong? Any ideas would be very appreciated.
>
> Best reards
> Christina
>
>

Ch
Sun Jan 09 17:51:27 CST 2005

Hi Marek!

I have checked that the textbox´s value acutally is written to the
myView.myField before the tableupdate command runs.

Christina


"Marek Hryceniak" <marek_usunto@mcm.pl> skrev i meddelandet
news:u7iYmrp9EHA.1392@tk2msftngp13.phx.gbl...
> Hi Christina,
>
> You are updating the view too early ;)
> Value from Textbox is written to the view field just AFTER the Valid event
> returns .T.
> Try to fire TABLEUPDATE(1,.F.,myView) in Textbox.LostFocus event.
>
> Best regards,
> Marek
>
> U¿ytkownik "Ch Löfberg" <ch.lofberg@telia.com> napisa³ w wiadomo¶ci
> news:4DADd.13578$d5.114591@newsb.telia.net...
> > Two users runing an VFP-app on workstation A and workstation B conected
to
> > a
> > LAN;
> > 1 User A enter a textbox based on myView.myField
> > 2 User B modifies the same textbox/field
> > 2B User B leaves the TEXTBOX and it´s valid fires (lcSuccess =
> > tableupdate(1,.F.,myView) && returns T)
> > 2C User B don´t leave the RECORD in myView
> > 3 User A can´t see the modification made by B.
> >
> > If user B leaves the record directly after the modifing everything works
> > just fine.
> >
> > But if user B don´t leave the specific record - user A can´t see the
> > modification. And an updateconflikt occurs.
> >
> > myView is optimistic rowbuffered, parameterized and contains one record
> > only. Exclusive is set off.
> >
> > What´s wrong? Any ideas would be very appreciated.
> >
> > Best reards
> > Christina
> >
> >
>