Uniface User Forum

 View Only

  • 1.  Verify Pathname after changing it dynamically

    Posted 25 days ago

    Hello,

    I used the "open" and "close" instruction to connect on differents databases, changing the PathName of the connector $MQL.

    However, I want to verify if the connection is done on the correct database after open a new one, even if the $Status = 0.

    (I have cases where I put something wrong in the pathname, and $Status=0 however)

    Is there a Uniface instruction which can give me the pathname actually used?

    Thanks



    ------------------------------
    Jérémie CEDOLIN
    Proges Plus
    Willems FR
    ------------------------------


  • 2.  RE: Verify Pathname after changing it dynamically

    Posted 24 days ago
    Edited by Osman Shariff 24 days ago

    Would this work using Sql Server 

    sql "SELECT DB_NAME()",$path

    {test the result}



    ------------------------------
    Osman Shariff
    ------------------------------

    Original Message


  • 3.  RE: Verify Pathname after changing it dynamically

    PARTNER
    Posted 24 days ago

    On MySql it appears that would be 
    SQL "select DATABASE()",$path



    ------------------------------
    Iain Sharp
    Head of Technical Services
    Pci Systems Ltd
    Sheffield GB
    ------------------------------

    Original Message