New Forum | Previous | Next | (P-PDF) Beginners
Topic: No Topic
Conf: (P-PDF) Beginners, Msg: 157800
Date: 1/26/2007 07:06 AM
I am looking for solution that is similar to the posting (Populate PDF from database) That was entered last November, I am using Designer 8.0 and am pulling data from a database (dataConnection1) and populating a drop down list. Then I am have binded Corp_Zip code field that resides in the same database via a separate connection (DataConnection3). This is to keep the primary uniform and the secondary to manipulate. When the form first displays it does pull the first record in the database, after I pull the drip down list the Corporate.rawValue is produced *I created a separate text field and feed it in, but my query does not pull.
I am using an access database via an access work group,
Code on button.
xfa.sourceSet.DataConnection3.#command.query.commandType = "text"
xfa.sourceSet.DataConnection3.#command.query.select.nodes.item(0).value = Concat("Select * from Corporate Where Corp_SeqNo = ",Corporate.rawValue, "")