How to fill info from database

[Former Community Member]

I have the database talking to livecycle. I am using OLEDB via the ODBC in server 2003 for the connection. I can access the database in PHP no problem using the ODBC functions.



All I want to do is query a customer ID and return a first and last name. The SELECT statement is simple however what goes in front and after the SELECT statement is not clear to me.



I just need a bare bones example to get going. with what the fields need and the button to execute the query.



Any help would be greatful.



Thanks in advance Charlie

[Former Community Member]

Is this data being retrieved after the user enters the Customer ID?



If so then you can set up th econnection to have a delayed open (so that you can control when the connection to the DB is established). There is a checkbox on the 2nd screen of the data connection wizard.



Now you can create the SQL statement and set a property of the DtaaConnection (programmatically) and open the data connection. If you post your email address I will send you a sample. You will not have my DB but you will get the idea.