RE: WHERE I USE SYS(1104) AND SYS(3050)
From: mk sharma
To: Andy Kramek
Westminster Circle, Akron
Ohio - United States
where i use sys(1104) and sys(3050)
RE: where i use sys(1104) and sys(3050)
Visual FoxPro 9
Thursday, January 18, 2007 2:06:22 PM
This message was rated by:
i have a sales invoice entry form, when 2 users enter data in same time.
user1 entered 5 products in grid and user2 entered 3 records in grid
when user1 save the buffered data first, it is displyed in grid of user2 with his buffered data.
when user2 save the buffered data first, it is displyed in grid of user1 with his buffered data.
can i solve this problem with sys() commands.
below linking showing this is a bug in vfp9.
> > where i can use below commands
> > sys(1104)
> > sys(3050)
> > can i use sys(1104) after tableupdate OR tablerevert command.
> > warm regards,
> > mk.
> Why do you want to use these commands - in all my years with VFP I have never actually needed to use either!
> Firstly because of the note on SYS(1104) that "The use of SYS(1104) will slow performance in applications that have a large number of buffered tables open" Check the Wiki for this one at
> Second because VFP 3.0/5.0/6.0 was originally written to work under Windows 9x OSs and its internal memory manager Doesn't Play Well with NT-based OSs. The SYS 3050 hack can help under certain circumstances. It doesn't help if your client doesn't have much memory to begin with. It doesn't help if (for some odd reason) you're still using a windows 9x OS - and can actually reduce performance in rare cases.
> In other words, its an OLD command for obsolescent systems! It should never be needed under anything later than WinNT/Win2K although there is some anecdotal evidence (unproven) that it can help if you are running on Citrix.
> Check the WIKI entry for this one at:
> Andy Kramek
> Microsoft MVP (Visual FoxPro)
Tightline Computers Inc, Akron Ohio, USA