Sage 100

 View Only

  • 1.  Query in Providex

    Posted 01-21-2021 13:01
    Edited by Lourdes Sobrino 01-21-2021 13:04
    I have a customer in Sage 2019 Advanced that is asking if I know how to do queries in Providex....They are in the need to implement a connector for a product called Prophix.  Any help on the room???

    ------------------------------
    Lourdes Sobrino
    LU² DSD Puerto Rico
    Guaynabo Puerto Rico
    787.485.9638
    ------------------------------


  • 2.  RE: Query in Providex

    Posted 01-21-2021 13:19
    Prophix the forecasting software?  Why not use the ODBC to extract information?  Large dataset?

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 3.  RE: Query in Providex

    Posted 01-21-2021 13:38
    Providex queries are close to regular SQL, with some odd things about how dates are handled.  Do they have any specific problems?


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Query in Providex

    Posted 01-22-2021 02:24
    Edited by Dan Burleson 01-22-2021 02:24
    ProvideX SQL Syntax

    ------------------------------
    Dan Burleson
    Software Consultant
    Connex Software
    Corvallis OR
    541-224-6642
    ------------------------------



  • 5.  RE: Query in Providex

    Posted 01-22-2021 09:45
    One important thing to note is that the ODBC driver is read-only.  Delete and update statements won't work.  Only select queries.

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------

    Original Message


Related Content