Skip to Content
0
Former Member
Sep 06, 2006 at 02:01 PM

Adobe LiveCycle Designer 7

34 Views

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." It can found at this address: http://www.adobe.com/devnet/livecycle/articles/lc_designer_db_lookup_tip.pdf#search=%22%22providing%20interactive%20database%20lookup%22%22 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:

http://img169.imageshack.us/img169/7250/errorbr6.png

Any suggestions on what I might be doing wrong? Also does anyone know of where I can get good information about how to script these forms to integrate with SAP? Thank you for your help.