Does anyone know how to activate the AlphaDAO Connections Dialog from xBasic?
This is the Dialog box that is normally activated from;
Tools->External Databases->AlphaDAO Connection Strings
The Tools menu option is available from the Control Panel.
Why you ask?
Please note the code is included for reference only, in case some else finds this post. It is not part of my explanation.
I have an application that will be used to extract information from a commercial application via passive link tables. The details of the tables being accessed are well established but the connection details are not. So in my configuration screen (form) the user enters details about installation they are connecting to. From the forums I've found out how to retrieve a list of defined connection string in a CRLF seperated list, which I use to populate a drop down in the my configuration form;
Also from the forums I've also learned how to build a passive link table under xBasic control.
On my configuration screen I would like to add a button that will take the user to where he can define the connection strings.
Why passive link table?
Because I'm mainly interested in configuration information in the commercial applications which are small tables. Also it's a medical application so the interaction with the actual application must be kept to a minimum (get in and get out).
This is the Dialog box that is normally activated from;
Tools->External Databases->AlphaDAO Connection Strings
The Tools menu option is available from the Control Panel.
Why you ask?
Please note the code is included for reference only, in case some else finds this post. It is not part of my explanation.
I have an application that will be used to extract information from a commercial application via passive link tables. The details of the tables being accessed are well established but the connection details are not. So in my configuration screen (form) the user enters details about installation they are connecting to. From the forums I've found out how to retrieve a list of defined connection string in a CRLF seperated list, which I use to populate a drop down in the my configuration form;
Code:
CnnctLst = a5_getsavedadoconnections("","AlphaDAO")
Code:
'Define the DataSource Delete DS DIM DS as P DS.ConnectionString = "::Name::ConnectName" DS.SQLSelectStatement = "select * from tableofinterest" DS.Arguments = "" Dim TableFileName as c TableFileName = "LocalCopyOfTable.dbf" 'delete the table as we always rebuild from scratch table.erase(TableFileName,.T.) 'show user what is going on and allow him to cancel Dim showProgress as l Dim allowCancel as l showProgress = .t. allowCancel = .t. 'preform the actual passive link table build Delete ResultP DIM ResultP as p ResultP = a5_PassiveLinkTableDefine(DS,TableFilename,showProgress,allowCancel) if ResultP.userCancelled = .t. then ui_msg_box("Notice","User cancelled") else if ResultP.HasError = .t. then ui_msg_box("Error",resultP.errorText) else ui_msg_box("Notice","File created: " + resultP.tablefilename) end if
Why passive link table?
Because I'm mainly interested in configuration information in the commercial applications which are small tables. Also it's a medical application so the interaction with the actual application must be kept to a minimum (get in and get out).
Comment