Hi,
after some testing and in contrast of what the documentation says, the connection (type of variable) WORKS with Mobile (v27) and HFSQL C/S and Classic.
But if you do not follow a strict sequence of assigns, it will fail - the sequence seems to be important only for HFSQL C/S, not for Classic
Here is what worked for me:
a360_DataBaseConnection is Connection
a360_DataBaseConnection.User = a360_CSUser
a360_DataBaseConnection..Password = a360_CSPassword
a360_DataBaseConnection.Server = a360_CSServer
a360_DataBaseConnection.Database = a360_CSDatabase
a360_DataBaseConnection.Provider = hAccessHFClientServer
a360_DataBaseConnection.Access = hOReadWrite
IF HChangeConnection("*",a360_DataBaseConnection)=False THEN
Info("Wrong connection setup - RDBMs")
RESULT(False)
END
// Open the main connection
IF HOpenConnection(a360_DataBaseConnection)=False THEN
Info("Wrong connection setup - RDBMs")
Info(ErrorInfo(errFullDetails))
Info(HError)
RESULT(False)
END
Regards
Steven Sitas
Edited 1 time(s). Last edit at 01/31/2023 08:05PM by SteveSitas.