Re: corruption with vfp 8 - continued

Hi Bill,
i'm not using anything special to limit memory, why do you ask?
i remember reading something about that on old win98 with a lot of ram,
but not in xp. please tell me more.

each computer is fairly modern, 3.2ghz max, 4 of them are 550mhz all with win2k or xp. each with 256mb min up to 1gb.
the problem has ocurred on:
sony vaio 3.0 xp 512,
clone, 500 xp 256
poweredge 512 win2k
sony 3.0 xp 512
dim2400 2.0 256 xp
optiplex gx280 3.2 1gb xp
those were the only computers out of 14.
and the problem seems to always occur during multiuser access.
i thought it could be networking, we have two switches piggy backed, one in each room, but it happened between 2 computers on the same switch as the server, unless that switch is going bad. but i'm not seeing any problems whatsoever on any other apps, but i dont think the other apps are sharing like foxpro is.

nothing makes sense as to why.

the other thing i'm thinking it could be is the different techniques i'm using in code, for example, each form is a separate data session, tables are opened usually using sql so the data is copied,
when i write back, i add/modify/delete thru one module with a separate data session using SQL commands, and a few other import modules change the data using APPEND FROM commands. some others quickly use a REPLACE comand, but these are rare. so i'm not sure if mixing SQL with APPEND creates an issue. the area which went south last nite was a payroll update, where the user prepares the data, and adds the account breakdowns, and after clicking save, i then lock the tables, then get the next available transaction number, and do a quick 'append from' and update the tran numbers and release the locks. i'm expecting tran numbers and record row keys to be unique, and in this case, my query to get the max didnt report records that another user just added so records got overwritten. i'm working on rewriting some of this logic, add more checking, etc. but i've been using this for other apps for some time and it works pretty solidly.



swdev2 wrote:
Hullo Jay -
What are you doing to LIMIT the amount of memory your compiled VFP app
consumes?
regards [Bill]
.

Loading