Hi!

I see no problem or anything related to hangs from VFP side in the sample commands you posted here. It looks like this is related to SQL Server and network administration. There is SQL Server forum here, try to post this thread there.

Use of _cliptext is quite intriguing and it might be a source of the memory increase on each workstateion, but I don't know exactly. Just try to make a simple program with loop and use _cliptext in the loop to see if this cause hangs or memory usage increase.

The memory increases also because VFP use a lot of internal buffers for each alias (record set) returned from the SQL server, as well as for all strings and string operations. You can force purge unused buffers by undocumented sys(1104) function (documented for VFP7), but VFP do this automatically in certain cases.

>How can we avoid “hangs”?
>The situation is: There is a client-server application. Client is Visual Fox Pro 6.0 sp 4
>Server is MSSQL 7.0. Server is Celeron 400, it’s memory is 196 MB. The example of the code is
>
>_cliptext = "select bl.cntr_num, p.pers_nm, bui.bui_adr,bui.bui_n,bl.square,bui.build_id, bl.bl_id,bl.y_debt,bl.yf_debt,bl.y_dat,bl.pay_dat as pay_dat1,bl.fine_val,p.pers_adr" + " " +;
> "from b_lease bl, person p, build bui where bl.build_id *= bui.build_id and bl.pers_id *= p.pers_id order by cntr_num"
>= SQLEXEC(Handle,_cliptext,'cursor_contract')
>…………………………………………………..
>SELECT cursor_contract
>USE
>…………………………………………………
>_cliptext = 'SELECT * from vw_b_lease where cntr_num = ?lccntr_num'
>=SQLEXEC(Handle,_cliptext,'b_lease')
>
>Usually 12 users work at the same time. Periodically users “hang”.
>It was noticed the more queries users do in the same connection the more memory is used.
>What should I do to avoid “hangs”?