Im new to working with Livecycle. I am attempting to connect to a SQL database. Im able to setup the connection easy enough and select the table i want to query, but when I enter the field in to the binding section and test it. the field only displays the first value. Ive tied it different ways with different types of objects (list box, combo box, ect) .any ideas what Im missing...?
When you create the connection in the Dataview by default the connection to the dB will happen when the form is loaded. Hence it will return the 1st record. In the data connection definition there is a delayed open checkbox on the last panel. If you check this off then you can control when the data connection happens. I have some samples that show how to get a SQL statement into the connection and cause it to open. If you post your email address I will send it to you.
Ive made my email address visable. Anything you can send me would be much appreciated.
I want to have a submit button on a form, that when clicked by the user can take the data and add it the database table which i made the connection to and of which the fields in the form were based on. Could you help with this or direct me to somewhere I can follow. It would be much appreciated.