sfSaveResult (Type of variable)

WINDEV, WEBDEV AND WINDEV MOBILE
ONLINE HELP

Version:

Home | Sign in | English

Properties specific to the description of sfSaveResult variables
Functions that handle the sfSaveResult type

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

sfSaveResult (Type of variable)

In french: sfRésultatSauvegarde (Type de variable)

The sfSaveResult type is used to find out the result of SFAdd and SFModify. The characteristics of this result are returned by several WLanguage properties.

Remark: See Declaring a variable for more details on the declaration of this type of variable and the use of WLanguage properties.

Versions 20 and later

This type of variable is now available for WINDEV applications in Linux.

This type of variable is now available for iPhone/iPad applications.

New in version 20

This type of variable is now available for WINDEV applications in Linux.

This type of variable is now available for iPhone/iPad applications.

This type of variable is now available for WINDEV applications in Linux.

This type of variable is now available for iPhone/iPad applications.

Example

// Connect to Salesforce
Cnt is sfConnection
Cnt..Login = "vince@gmail.com"
Cnt..Password = "qwerty" + "XXB12VCZ54"
IF SFConnect(Cnt) = False THEN
Error("The connection failed")
RETURN
END

// Retrieve the data
ResQuery is sfExecuteQueryResult
ResQuery = SFExecuteQuery(Cnt, "SELECT Date__c,Miles__c,Contact__c FROM Mileage__c")

ARecord is sfObject
FOR EACH ARecord OF ResQuery..Object
Trace("---- Type: " + ARecord..ObjectType + " | ID: " + ARecord..ID)
Trace(ARecord..Date__c + " / "+ ARecord..Miles__c + ...
" / "+ ARecord..Contact__c)
END

// Modify the data
ARecord = ResQuery..Object[1]
ARecord..Miles__c = 698 // Modification
arrObjects is array of 1 sfObject
Add(arrObjects, ARecord)

// Add a new data
NewRec is sfObject
NewRec..ObjectType = "Mileage__c"
NewRec..Date__c = "2009-02-15"
NewRec..Miles__c = 222
Add(arrObjects, NewRec)

arrRes is array of sfSaveResult
arrRes = SFModify(Cnt, arrObjects, sfCreationIfNotFound, "IDExternal")

FOR EACH res OF arrRes
Trace("Success = " + res..Success + " | Created: " + res..Created)
END

Remarks

Properties specific to the description of sfSaveResult variables

The following properties can be used to handle the result of SFAdd and SFModify:

Name	Type used	Effect

Created	Boolean	True if the record was created, False if the record was modified or if an error occurred.
Error	Array of sfError	Status report of errors.
ID	Character string	Identifier of created or modified object. This property is available in read-only.
Success	Boolean	True if the modification or the creation was performed, False otherwise.

Remark: These properties can be used with one of the following syntaxes:

<Variable name>..<Property name>
<Variable name>.<Property name>

Functions that handle the sfSaveResult type


Versions 14 and later SFAdd New in version 14 SFAdd SFAdd	Creates a record in a file of a Salesforce database.
Versions 14 and later SFModify New in version 14 SFModify SFModify	Modifies the records of a file defined in Salesforce.