Looking for suggestion. We have application which uses ODBC connection to SQL, at this point all users have ODBC connection installed on their local machines. We want to add another query to AS400. What application does, it opens text dialog box asking user to enter first few characters (this is a search). Next our lotus script searches both SQL and AS400 for matches and display them in the dialoglist. User then select item and form is updated. Is there any way we can set up application so we don’t have to load another ODBC connection on all users PCs. RunOnServer agent won’t work because we can interact with it.
You could interact with a RunOnServer agent if you use code to create a temp doc with the query in, and pass that document as a parameter to the RunOnServer agent. The RunOnServer agent can store information back into the temp doc. You can then retrieve the document in your script and get the values from the SQL server. The script doesn’t continue until the RunOnServer agent has completed. I can’t remember if you need to delete the NotesDocument object and retrieve it again with GetDocumentByUNID in order to access the fields added by the RunOnServer agent.