I am currently learning how to use Adobe LiveCycle Designer 7.0. My employer gave me the file to install a trial version along with pdf files with tutorials explaining how to use it. I am having trouble with the tutorials that involving scripting. Though I copy the script code directly from the pdf and follow the instructions. I have a hard time getting it to work correctly.
The one that I have had the most problem with is the tutorial entitled "Providing Interactive database lookup from forms. I followed the instructions to create a new data connection from the mdb file provided. There was a script to populate a drop down box that I was able to get to work after changing the syntax a bit. However the script that is on the button to execute the query I couldn't ever get to work.
Here are the instructions copied directly from the pdf.
13. Select the Refresh object. In the Script Editor, choose the following:
Show: click
Language: FormCalc
Run At: Client
14. In the Script editing area, type the following code:
if (Len(Ltrim(Rtrim(SelectField.rawValue))) > 0) then
$sourceSet.DataConnection.#command.query.commandType = text
$sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat(Select * from OfficeSupplies Where ID = , Ltrim(Rtrim(SelectField.rawValue)) ,)
//Reopen the Dataconnection
$sourceSet.DataConnection.open()
endif
Whenever I click the button I received the following error:
Any suggestions on what I might be doing wrong?