Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

StevenLohPK
StevenLohPK
Offline

Badges

Badges
6

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
13

Discussions

Discussions
0

Questions

Questions
4

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by StevenLohPK
Customize the badges you want to showcase on your profile
Can Adobe LiveCycle Connect to SQL CE? - Adobe LiveCycle 24-04-2012
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:\MyData\MyData.sdf" but it's not working, error prompted "Could not connect to the database". The same connection string works perfectly in VBA. Does that means SQL CE is not a supported database for LiveCy...

Views

419

Likes

0

Replies

0
Re: Value Passing During openDoc() - Adobe LiveCycle 19-10-2011
Hi Radzmar,Thanks for the reply. This is indeed a good piece of information.Regards,Steven

Views

231

Likes

0

Replies

0
Re: Value Passing During openDoc() - Adobe LiveCycle 19-10-2011
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" package upon closing the form? Is the garbage collector being triggered automatically as we close the form. I'm just worried that it will slow down the computer performance as more data are being broadcas...

Views

216

Likes

0

Replies

0
Value Passing During openDoc() - Adobe LiveCycle 19-10-2011
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 form to the second form? For example, form A and form B both have a text field called "First Name". So when form A opens form B, the "First Name" text field in form B should be filled by the value pass ...

Views

1.4K

Likes

0

Replies

6
Re: Dropdown List Not Refresh with Static PDF - Adobe LiveCycle 03-10-2011
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 to be refreshed everytime users open the file:xfa.sourceSet.Product.requery()xfa.sourceSet.Product.close()xfa.sourceSet.Product.open()However, the DDList still won't get updated with changes made in th...

Views

235

Likes

0

Replies

0
Re: Dropdown List Not Refresh with Static PDF - Adobe LiveCycle 15-09-2011
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?Steven

Views

241

Likes

0

Replies

0
Re: Dropdown List Not Refresh with Static PDF - Adobe LiveCycle 14-09-2011
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

Views

238

Likes

0

Replies

0
Re: Dropdown List Not Refresh with Static PDF - Adobe LiveCycle 13-09-2011
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" using SQL Query "SELECT ProductCode, ProductName FROM PUB_Product WHERE ActiveInd=yes" whereby it will only extract the "active" products.Binded the product code dropdown list with "Product" data connect...

Views

241

Likes

0

Replies

0
Dropdown List Not Refresh with Static PDF - Adobe LiveCycle 12-09-2011
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 FROM PUB_Product WHERE ActiveInd = yes"Everything works perfectly when I save my PDF in dynamic form. However, due to some limitation with dynamic form, I have no choice but to save the PDF in static form. Probl...

Views

2.2K

Likes

0

Replies

8
Re: Comment on Dynamic PDF - Adobe LiveCycle 12-09-2011
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

Views

219

Likes

0

Replies

0