Skip to Content
avatar image
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 comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • 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 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