Home Forums CoreObjX / DB Foxpro support

This topic contains 7 replies, has 5 voices, and was last updated by  sacadev666 3 weeks, 6 days ago.

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #9851

    paul2
    Participant

    Hi

    Does anyone have any FoxPro examples for this software? How to you call this object ? Insert the control on a form (I can’t see one!) or call it by createobject and if so what is the object name ?

    Thanks in advance for any help

    #9863

    Tom Crawford
    Keymaster

    Here is a simple sample provided by one of our customers:

    CoreObjx_conn = “coreobjx70.qbconnection”
    CoreObjx_List = “coreobjx70.ListEntries”
    CoreObjx_app_name = YourAppName
    CoreObjx_Access_Code = YourLicNumber

    Conn = Createobject(COREOBJX_CONN)

    Now you are connected, after that, you can call any of the PEMs that CoreObjx has:

    Examples:
    ? conn.company.name
    CustomerList = conn.company.customer.getall()
    ? customerlist.item(1).name
    ? customerlist.item(2).name

    Hope this gets you started.

    #9868

    Tom Crawford
    Keymaster

    Here is another response from a FoxPro customer:

    see attached objxconnect.prg Put this prg in yourFoxPro project and reference it every time you want to expose a specific quickbooks object.

    * — The below example is going to Sales Orders and getting txnid,refnumber, and customer by RefNumber.
    * — Also tell him to go to command window to expose the conn object for looking up object details – ie
    * — conn.company.salesorders.item. can be typed into the FoxPro command window after running this objxconnect.prg
    * — to see all available fields.
    DO objxconnect.prg
    WAIT “” TIMEOUT 1

    conn.company.salesorders.includedataextensions = .T.
    CONN.company.salesorders.CLEAR
    CONN.company.salesorders.GetByRefNumber(lcDBFRefNu,lcDBFRefNu)

    CREATE CURSOR curSaleOrd ( TxnID c(43) NULL, RefNumb c(50) NULL, CustName C(100) NULL )

    FOR i = 1 TO conn.company.salesorders.count()
    SELECT curSaleOrd
    APPEND BLANK
    replace txnid WITH conn.company.salesorders.item(i).txnid
    replace RefNumb WITH conn.company.salesorders.item(i).RefNumber
    replace CustName WITH conn.company.salesorders.item(i).Customer
    ENDFOR
    conn.CloseConnection()

    #9879

    paul.oxley
    Participant

    This is great. Thanks for the help

    #9902

    paul.oxley
    Participant

    Can anyone help with any sample code VFP or VB for creating invoices ?

    Thanks in advance

    #9918

    Tom Crawford
    Keymaster

    In the coreobjX installation folder you will find a samples sub folder. This contains several VB sample applications.

    #9972

    psass
    SDN Member

    Hi,

    Evening to all,

    I have a pretty good working knowledge of the CoreObjx DLL and how to use it in Visual FoxPro.
    I am the author of the “objxconnect.prg” mentioned above that instances a conn. object that then can be used with Visual FoxPro intellisense to drill down into the exposed calls contained inside the CoreObjX70.dll

    I could be contacted privately at my email address psass@vianet.ca

    Pete,

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic.