Maximizer > Support > Knowledge Base Search New - Searching Tips Disclaimer
 Answers 
   
  Help  
Search Results
Related Answers
Product

  
Category

    
Search Text (optional) Search Tips? 
   
Search by      Sort by

Powered by RightNow Web
  Reference #  
090403-000000
  Product  
Maximizer
  Multiple Versions
  Category  
Integration
  Customization
  Date Updated  
04/07/2009 09:30 AM

 Print  Print Answer
  
  Deleting records with MaAccess must use Data_Machine_Id and Sequence_Number
  Question
 

Deleting records with MaAccess must use Data_Machine_Id and Sequence_Number

Problem

When calling Delete from MaAccess, if you don’t supply the Data_Machine_Id and Sequence_Number when those fields are available, the Delete will either not remove any records or remove multiple records.

Reason

This is by design. This is a requirement for Delete with MaAccess.

  Answer
 

Solution

Always provide the Data_Machine_Id and Sequence_Number when calling delete like in the following example with Notes:

Set objMaNote = objMaHost.CreateObject("Notes", varLogin)

objMaNote.Clear
objMaNote.Data_Machine_Id = 912345672
objMaNote.Sequence_Number = 45
objMaNote.Client_Id = "001002000613063671156C"
objMaNote.Contact_Number = 0
objMaNote.Date = "9/1/2008 12:00:00 AM"
objMaNote.Time = "1/1/1900 10:59:18 AM"

If objMaNote.Delete Then

MsgBox "Note Delete Success"
Else
MsgBox "Note Delete Failure"
End If

Versions Affected

  • Maximizer Enterprise 9
  • Maximizer Enterprise 9.5
  • Maximizer CRM 10
  • Maximizer CRM 10.5
 
  How well did this answer your question?
 
100% 0%   
Back
  Back to Search Results