Thanks Jeff. I have checked the sql logs for the insert statement and didn't seem to contain note,description fields in any statements.
It seems to insert as below:
(1,'20101207 00:47:32',1,'20101207 00:47:32','20101207 00:47:32',-2147483640,411)
Then I tried to query one of the records with description and note fields with values as below:
objQueryEntityRequest.entityname = "communication";
objQueryEntityRequest.id = pId;
objQueryEntityRequest.SessionHeader = crmSessionHeader;
objQueryEntityResponse = CRMService.queryentity(objQueryEntityRequest);
But unfortunately the above didn't return the note and description values (only contains null values).
In the other hand while querying for all the communication records as below:
objQueryRecordRequest.fieldlist = "";
objQueryRecordRequest.entityname = "communication";
objQueryRecordRequest.queryString = "";
objQueryRecordRequest.orderby = "";
objQueryRecordRequest.SessionHeader = crmSessionHeader;
objQueryRecordResponse = CRMService.queryrecord(objQueryRecordRequest);
queryrecordresult myQueryRecordResult = objQueryRecordResponse.result;
crmrecord myRecordList = myQueryRecordResult.records;
The above record list seems to return all the notes,description and rest of the fields.
Why would this happen?