Hi All,I have an application which stores its data in a SQL CE database (*.sdf). I'm just wondering if it is possible to create a database connection from Adobe LiveCycle Designer ES2 to this .sdf file. I've tried this connection string "Provider=Microsoft.SQLSERVER.CE.OLEDB.3.5;Data Source=C:\MyDat...

Hi Radzmar,Thanks for the reply. This is indeed a good piece of information.Regards,Steven

Hi Niall,This is exactly what I am looking for. Thanks a lot!!! Another question to this app.media() method. I pressume the "broadcast" data are being stored in the computer memory in order for the other forms to be able to pick up the value. In this case, are we suppose to dispose the "myData" pac...

Hi All,I'm hoping someone here can help to solve my puzzle. I'm currently developing my PDF form using Adobe LiveCycle ES2. From the main form, I have a button which open another PDF form using the app.openDoc() method. I'm wondering whether there is a way to pass some of the values from the main fo...

Hi Paul,Sorry for not responded for so long as my harddisk was corrupted two weeks ago and only manage to recover everything back last week.I've tried the method from your last reply. Instead of entering the code to preOpen event, i've added lines below to initialize event as we only need the list t...

Hi Paul,By changing the code as you suggested, I believe it does trigger the query to re-run as I could see the DDList was defaulted to other value which was not in the original list. However, the DDList was still not updated with the new item. Is there anyway to refresh the DDList or something?Stev...

Hi Paul,Tried what you've suggested both in FormCalc and JavaScript but no luck here. The DDList just won't get refreshed =(Regards,Steven

Hi Paul,Thanks for helping. I'm using Acrobat to view the PDF form. Thus, shouldn't have any problem connecting to the database.I've captured some screenshots as below and hope it helps you understand my situation better.This is my Access databaseThis is my PDF. Added a data connection "Product" usi...

Hi,I'm using LiveCycle ES2 version 9 to design my form and view using Acrobat X Pro. In my form, I have a dropdown list that binds to a data connection to populate the list of products available. The SQL query of the data connection is as simple as below,          "SELECT ProductCode, ProductName FR...

Hi Niall,Great job there. I've tested the PDF and it is working with my Acrobat X Pro. This will be really helpful for me. Thanks man!Steven