SOLVED
Is lookup dialog possiable with LC?
1 Accepted Solution
Correct answer by
Hi Bill,
It sounds like you are doing a lot of processing of the data. Are you using a standard dropdown from the Stnadard Object library or a data dropdown from the Custom Object library?
I would recommend the data dropdown, as it comes with data connection script built-in. All you need to do is hook it up to a data connection and tell it what tables/columns to use. The three <value> items is all that you have to change.
I know that the script here is in the initialize event, but just run with that initially. We have used several data dropdowns in forms and have not had too bad a performance.
Give this a try first and if performance is still an issue, try moving this script to the preOpen event. I would strongly recommend Stefan Cameron's blog and in particular:
Connecting a Form to a Database - Stefan Cameron on Forms
Selecting Specific Database Records - Stefan Cameron on Forms
Databases: Inserting, Updating and Deleting Records - Stefan ...
Displaying All Records from an ODBC Data Connection - Stefan ...
There are many more, but these should help.
When I said you could build the dialog natively, I meant Adobe have exposed this method and you can use javascript to build the dialog from scratch. It can be done, but I have done it! If you do a search through the Acrobat (not LC Designer) reference documents for execDialog, you will see the methods that are available.
I use AcroDialog from Windjack Solutions. It is an Acrobat plugin that gives you a drag and drop approach to creating dialogs. You can then copy the javascript that AcroDialog builds for you and paste it into LC Designer, for example into a button event. Then you stitch in the logic, eg where user data inputting into the dialog ends up in a form field or some other action.
Hope that helps,,
Niall
Hi Bill,
No problem!
I use AcroDialog from Windjack Solutions (http://www.windjack.com) to generate dialogs. You can pass data from the form to the dialog and back again. This is relatively straightforward.
I have not create a dialog that connects to a database, however on http://www.pdfscripting.com (part of Windjack Solutions) they have a sample dialog that connects to a database. I can't share that dialog, but here is a screenshot.
Maybe if you contact Windjack directly.
Good luck,
Niall
Hi Paul,
Checked that the OLEDB will available if I launch Designer outside of workbench.
I also got a reply from Adobe support, they said that launching designer from workbench do not have OLEDB is as design, because you won't want to create DSN for every client.
I think they mean I will need to create the DSN for every client who use the from, because OLEDB will connect to the DB directly at client level.
I just have no idea why they try to make decision on what I want 
.
But anyway, thanks for the suggestion, because I am about to try install the standalone designer to see if it will get the OLEDB option, your suggestion saved me a lot of times.
Regards
Bill
