On MySql it appears that would be
SQL "select DATABASE()",$path
------------------------------
Iain Sharp
Head of Technical Services
Pci Systems Ltd
Sheffield GB
------------------------------
Original Message:
Sent: 04-05-2024 04:46
From: Osman Shariff
Subject: Verify Pathname after changing it dynamically
Would this work using Sql Server
sql "SELECT DB_NAME()",$path
{test the result}
------------------------------
Osman Shariff
Original Message:
Sent: 04-04-2024 07:59
From: Jérémie CEDOLIN
Subject: Verify Pathname after changing it dynamically
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
------------------------------