Insert Null Values into Salesforce

[Sidharth]

Hello All

I have a outside application build on C# which accesses my Salesforce DB.

When i try to insert NULL values form C# app to SF, it doesnt effect anything. 

I have defined my variables in C# app as Nullable, and can see that its sending NULL values, but still no effect in SF.

Any ideas?

Thanks

Sid

[SimonF · Accepted solution]

You need to use the fieldsToNull property on SObject, e.g. to set field "foo__c" to null, you'd do

Account a = new Account();

a.Id = 'someId';

a.fieldsToNull = new String [] { "Foo__c" };

SaveResult sr = stub.update(new SObject [] {a});

[Sidharth]

Thanks a lot :)