I am attemping to insert purchaes order lines with a empty string description but the description defaults to the Item description. Is there any syntax or maybe special character I can use to trick qodbc into thinking there is a value there elminating the default item description.  I do not want to put garbage into the description field, in order to prevent the default value from showing?

I have tried the following quries with no success:

Insert into PurchaseOrderLine (PurchaseOrderLineItemRefListID,PurchaseOrderLineDesc,PurchaseOrderLineQuantity,PurchaseOrderLineRate,PurchaseOrderLineCustomerRefListID,FQSaveToCache) Values ('240000-1071531214','',1,10,'900000-1197741925',1)

Insert into PurchaseOrderLine (PurchaseOrderLineItemRefListID,PurchaseOrderLineDesc,PurchaseOrderLineQuantity,PurchaseOrderLineRate,PurchaseOrderLineCustomerRefListID,FQSaveToCache) Values ('240000-1071531214',null,1,10,'900000-1197741925',1)

Insert into PurchaseOrderLine (PurchaseOrderLineItemRefListID,PurchaseOrderLineQuantity,PurchaseOrderLineRate,PurchaseOrderLineCustomerRefListID,FQSaveToCache) Values ('240000-1071531214',1,10,'900000-1197741925',1)

QODBC passes requests to the Intuit qbXML SDK to process within QuickBooks. You can override a description, but you can't tell it not to use the default description. I suggest you delete the purchase description or setup new items with no purchase description.