Skip to Content
author's profile photo Former Member
Former Member

Adobe LiveCycle Designer 7

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 06, 2006 at 02:18 PM

    Hi Jason,

    as you are using the Adobe stand-alone Designer and tutorials, you should direct your questions directly to Adobe (probably on their website) as the samples shipped with the stand-alone product do not necessarily work in the SAP environment.

    For SAP integration, you need to install SAP NetWeaver AS(demo versions, for example, here in SDN on the download site) and use the versions of the Adobe components delivered by SAP. SAP also provides tutorials for the Interactive Forms integration in Web Dynpro.

    Start looking at this topic on the SDN homepage at http://sdn.sap.com/irj/sdn/interactiveforms where you will also find many links.

    You can connect to SAP using the Adobe stand-alone products, too, but given Adobe's development partnership with SAP, this approach doesn't make much sense - and it is, as I stated above, a question for Adobe, not SAP.

    Kind regards,

    Markus Meisl

    SAP NetWeaver Product Management

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      I already have directed my questions directly to Adobe. I posted a message almost identical to this one to their forums Friday and it has been completely ignored, which is why I am posting here now.

      Thank you for your help.

      Jason

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.