Re: no responding, when i use rlock function

Hello

I already delete CDX file and FPT file
The file only 2 record and the size only 4KB

When i using 2 computer the run this application, one computer can append
blank, but another cannot (no responding)
I dont know why ? and how to fix it ?

and If i using VFP6 to re-compile the application there is no problem

Thanks for help
Teddy

"Lee Mitchell" <Leemi@xxxxxxxxxxxxxxxxxxxx> ¼¶¼g©ó¶l¥ó·s»D:P$ATV$MrGHA.4272@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Izzue:

Did you delete the index file (CDX) when you tried it?

If you add just one index tag, do you see the problem?

How large in size and number of records is the table?

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no
rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:
http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003


Hello

I found that if i remove all the index , i can use the below code to add
data
but if i remove and create the index again, the it still no responding ?
how can i fix the problem ?

thanks for help
teddy



"Lee Mitchell" <Leemi@xxxxxxxxxxxxxxxxxxxx>
¼¼g©ól¥ó·s"D:bmZN0PBrGHA.1572@xxxxxxxxxxxxxxxxxxxxxxxx
Hi Izzue:

This almost sounds like file corruption. Do you have an index file or
memo
file with the table? I would delete the index file and recreate the
table
from scratch and try the code again.

Have you tried SET TABLEVALIDATE TO 0?

I hope this helps.

This posting is provided "AS IS" with no warranties, and confers no
rights.

Sincerely,
Microsoft FoxPro Technical Support
Lee Mitchell

*-- VFP9 HAS ARRIVED!! --*
Read about all the new features of VFP9 here:
http://msdn.microsoft.com/vfoxpro/

*--Purchase VFP 9.0 here:

http://www.microsoft.com/PRODUCTS/info/product.aspx?view=22&pcid=54787e64-52
69-4500-8bf2-3f06689f4ab3&type=ovr

Keep an eye on the product lifecycle for Visual FoxPro here:
http://support.microsoft.com/gp/lifeselectindex
- VFP5 Mainstream Support retired June 30th, 2003
- VFP6 Mainstream Support retired Sept. 30th, 2003



Hello

I also found that only my computer is not no responding, and my computer
can
add a record
but another computer have no responding, this 2 computer also using winXP
Is that the computer missing some DLL file on system32 ?

Please help, Thanks
Teddy


"Izzue" <teddy1218@xxxxxxxxxxxxxxxx>
¼¼g©ól¥ó·s"D:O7oVfb7qGHA.4676@xxxxxxxxxxxxxxxxxxxxxxx
Hello

But i found that , only one table use APPEND BLANK will no responding
I using the same code to append blank another table , there is no
problem

I already Set Reprocess TO 3 and "Set Exclusive OFF"
how can i fix the problem ?

Thanks
Teddy



"Stefan Wuebbe" <stefan.wuebbe@xxxxxx>
¼¼g©ól¥ó·s"D:O25zehxqGHA.3256@xxxxxxxxxxxxxxxxxxxxxxx

"Izzue" <teddy1218@xxxxxxxxxxxxxxxx> schrieb im Newsbeitrag
news:edtbT2wqGHA.4508@xxxxxxxxxxxxxxxxxxxxxxx
Hello

I am using VFP9.0 SP1 to develop the application
I create a "Add New" button to call another form and insert data to
table

but when i click it, the screen will no responding , how can i fix it?
<...>
"Add New" button source code

SELECT("CLIENT")
APPEND BLANK
IF RLOCK()
REPLACE code WITH "0001"
ENDIF

See "Set Reprocess" and "Set Exclusive" in help.
Usually there is no need for manual locking, as long as you use
table buffering.


hth
-Stefan




.

Quantcast