Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to fill info from database

Not applicable
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
1 Reply
pguerett
Level 10
Level 10
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.