Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance issue with quickbooks
Message
De
08/12/2009 05:55:31
 
 
À
07/12/2009 17:53:27
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
01437764
Message ID:
01438017
Vues:
58
>>customer1.GetByName ("cust name")
>>?customer1.CustomerAddress()
>>set the fields required and then
>>customer1.Add()


You can achieve something very similair directly;
loQbsession=CREATEOBJECT('QBFC5.QBSessionManager')
loQBRequest= loQbsession.CreateMsgSetRequest("UK",<XMLVersion>,<XMLMinorVersion>)  && set for your country/version

loCustomer=loQBRequest.AppendCustomerAddRq()

WITH loCustomer
  .CompanyName.SetValue("<Customer Name>")
  .BillAddress.addr1.SetValue("<Address Line1>")
  .BillAddress.addr2.SetValue("<Address Line2>")
   *! etc etc.
ENDWITH
  
loResponse = loQBSession.DoRequests(loQBRequest)    && Save Details

*! or to modify an existing
loCustomer = loQBRequest.AppendCustomerModRq()
FYI: from my experience speed is VERY dependant on network, local queries on machine with QuickBooks installed have a reasonable performance, when accessed across network performance deteriorates significantly (another reason for a server based approach?)

Gary.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform