![\"The](\"https:\/\/alt2.minisoft.com\/support\/wp-content\/uploads\/2015\/06\/ConfigDBConn.jpg\")
<\/a>The Configure database connection window<\/p><\/div>\n
1. If you haven\u2019t done so already, from the Project Properties > Database tab add a new database reference by selecting New.<\/p>\n
2. The Configure Database Connection dialog box displays. Enter the 3. Once the database has been configured select Test to confirm the connection. Once complete, click OK.<\/p>\n For more information, view the following tutorial: Where to set up your database connection<\/a> 4. The database name will display on the Project Properties > Database tab. Select Activate so that the information from the database becomes \u201creal-time\u201d data. Once complete, click OK.<\/p>\n 5. Create a variable containing the value you want to find in your database.<\/p>\n 6. Add the Right Trim and Left Trim<\/a>\u00a0function to the variable. This removes any possible leading and trailing spaces that would cause your lookup to fail.\u00a0TIP: To confirm the value, view the results in the Variables Viewer window.<\/em><\/p>\n 7. Create a second variable to be populated by the first item in your SELECT statement. If more than one column of data will be returned create those variables now. From the Variables placeholder in the Project window, right click and select Variables > By Position.<\/p>\n 8. Give your new variable a name and then select OK.<\/p>\n 9. Select your newly created variable, right-click, and select Function > SQL Lookup.<\/p>\n 10. The SQL Lookup dialog box appears. In the database dropdown box, select the database you want to access.<\/p>\n 11. Enter the SQL Statement you want executed. Use \u201c?\u201d as replacement characters for parameters you want to pass to the statement.<\/p>\n 12. Add parameters in the order you want the \u201c?\u201d replaced in your statement.<\/p>\n 13. If you are returning more than one column of data, add the additional columns, selecting the variable you want the returned value stored in the \u2018Additional columns assigned to\u2019 field.\u00a0NOTE: For complex queries write a stored procedure and execute it. The stored procedure must return a result set, not just a value.<\/em><\/p>\n eFORMz Table Lookup<\/a> The purpose of an SQL Lookup is to return additional data to an eFORMz project based upon a value in a data file. Normally this value is an indexed item to a table in a database. Step One: Setting up the Connection 1. If you haven\u2019t done so already, from the Project Properties > Database […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[91,10],"tags":[84,338],"_links":{"self":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5898"}],"collection":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=5898"}],"version-history":[{"count":7,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5898\/revisions"}],"predecessor-version":[{"id":8176,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/5898\/revisions\/8176"}],"wp:attachment":[{"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=5898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=5898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/alt2.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=5898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}database name<\/code>, driver class<\/code>, and url<\/code>.<\/p>\n
\nA the list of\u00a0supported databases and their URLs is available here: Supported URL and Driver Classes<\/a>
\nTo troubleshoot a connection, view the following reference: Troubleshooting a Database Connection<\/a><\/p>\nStep Two: Implement SQL Lookup<\/h2>\n
Additional Resources on Databases<\/h3>\n
\nLoading Multiple Rows with SQL Load<\/a>
\nCalling Database Stored Procedures<\/a>
\nCalling Database Functions<\/a>
\nTroubleshooting: SQL Error – The Statement Didn’t Return a Result Set<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"