Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Business Objects with delted records
Message
 
 
To
02/09/1998 08:55:42
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00131990
Message ID:
00132326
Views:
12
>>You can put !DELETED() in the filter of the index expression. If you do this you should also have an index tag on DELETED() - this will help Rushmore Optimization.
>
>Yes I was indeed overcomplicating my life, but that doesn't answer the important question: How can I RECALL a DELETED record using the bIZOBJ?

When a view is open, the table it is based on is also open. You may want to try selecting the table, performing the recall, and then selecting the view, and calling Requery().

I dont know how safe that is.

Another thing you could try is to create a form class with a private datasession and open the table and perform the RECALL.

DEFINE CLASS HiddenRecallForm AS FORM
DataSession=2 && Private Datasession
PROC ExecuteRecall(tcTable,tcCommand)
USE &tcTable
&tcCommand
USE
ENDPROC
ENDDEFINE

IOW Instantiate the form from the bizobj but dont show it:

loRecall = CREATEOBJECT("HiddenRecallForm")
loRecall.ExecuteRecall("MyTable","RECALL FOR cMyName =[Rick]")
RELEASE loRecall

REQUERY()

Notice that I dont base the form on the c-layer
Rick Hodder
MCP Visual Foxpro
C#, VB.NET Developer
Independent Consultant
www.RickHodder.com
MyBlog
Previous
Reply
Map
View

Click here to load this message in the networking platform