Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to delete a free table record?
Message
From
17/05/2002 02:35:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/05/2002 01:42:18
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00658004
Message ID:
00658012
Views:
14
This message has been marked as the solution to the initial question of the thread.
>Hi all:
>
>I am having problems with a form that is populated using the scatter and gather commands. when the user clcikc the first Delete button, they are presented with another form requesting confirmation to delete. The click event of the confirmation form has the following code.
>
>
delete
>skip
>if eof()
>	go bottom
>endif
>thisform.release()
>
>The user will now be at the original form. The original form has the following settings in the Init()
>
>
select 50
>use patient order tag last_name of patient.cdx
>set multilock on
>CURSORSETPROP("Buffering", 5, "patient")
>
>Problem: Each time I delete a record, it appears to be deleted in that the deleted record does not show up on the original form during navigation. However, when I exit the form and return, the deleted record always shows up!
>
>Any suggestions? TIA.

Ravi,
You have a table buffering and I guess 'delete' is also done with buffering. Put a tableupdate() after delete.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform