KRM240_

Drop Down field - Adobe LiveCycle

I have a drop down that is pre-populated from Access.The drop down uses both values and text description.ie: 1, Level 1; 2, level 2; 3, Level 3 etcIn another section of the form, I need to retrieve the text description of a specific value of a drop down based on a different field value.So my question is:If I have the drop down populated already, how do I retrieve the text value of item X from a button?Note: The drop down may be set at 1 (Level 1), I need to retrieve the description of 5 (Level 5...

329

Re: Update and Insert Into query into Access DB - Adobe LiveCycle

I have been trying to build one.But if I do not know the exact syntax options, it becomes difficult 🙂If I knew where to look for the documentation for this code, then the building of a sample becomes much easier.Ken

186

Re: Update and Insert Into query into Access DB - Adobe LiveCycle

Yes, this is what I am looking for.Where can I find the syntax (or an example) for this?

187

Re: Update and Insert Into query into Access DB - Adobe LiveCycle

Unless I am missing something, your link provides a sample on how to use a select queryie: SELECT id as catId, name AS catName FROM movie_categories GROUP BY name ORDER BY name;I have the SELECT query working using the WHERE clause to get a spcific record. Works great.I use this to pre-populate the form. Once I have the forms edited via data input from the users, they send the forms back to an administrator who has the ODBC connection and this admin person will update the database. I would prefe...

184

Update and Insert Into query into Access DB - Adobe LiveCycle

I have seen examples (and have them working) of the select * queries with Access to prepopulate a form.My question is is it possible to use a data connection with an update or INSERT INTO queryI have seen an example on PDF Scripting with hidden fields and connecting to the Database, then update the hidden fields to update the databaseI see how this would work, but means I need to have 2x the data fields in my form. To get away from this, I was hoping to have another option.What I would like to d...

1.9K

Re: Drop Down referencing - Adobe LiveCycle

Yes!this.boundItem(xfa.event.newText) works here!Many thanks

152

Drop Down referencing - Adobe LiveCycle

I have a drop down list as follows:Text, valueJan, 1Feb, 2....Dec, 12Select Mth, 0 (Default)I wish to use the change event and get the new value.this.xfa.event.newText = the new selected TEXT itemthis.xfa.event.prevText = previous selected TEXT itemthis.rawValue = VALUE of the previous selected itemQuestion: How do I get the VALUE of the new selected item?

623

Re: Drop Downs - Adobe LiveCycle

Thanks allfrom the example I could see what I was doing wrongI found that you need to set the DD.rawValue = to the hidden value that you want, not the Display value (assuming that the 2 are different)

131

Re: Drop Downs - Adobe LiveCycle

Sorry - should have been more explicitWould like to set these values using JS and if possible, by using either the text value or the hidden value..

131

Drop Downs - Adobe LiveCycle

Question on drop downs:How does one PRE set a drop down list value with a set choice. (ie: not changing the raw data behind the drop down but choosing one value to initially display - eg: select the current yr within a group of years)Interested in knowing how to set using specific text within the list specific value of the text selected

776

Re: Ascii Codes - Adobe LiveCycle

Thanks - this solved my issue.

425

Ascii Codes - Adobe LiveCycle

Is there a function that can convert an ascii code to the proper character?ie: in excel, one can use code() and char() to go back and forth.Found some ref to \u0041 = A, but not sure if this is the right method?Any assistance greatly appreciated.

1.5K

Button to save XML Data - Adobe LiveCycle

Trying to create a button to save the form data in xml format with a specified path and file name.My understanding is this is not possible.It is possible to save but the user must choose the file name and path. ie: xfa.host.exportData("", false);Is this true even if using a trusted function??Can some one please confirm this.Also, if I can not save XML, can I save in another format (ie: text) to a specified path and file name?Next, if not possible, I read that the doc must be certified and then I...

434

Re: Sample Forms - Adobe LiveCycle

If you did a standard instal, look hereC:\Program Files (x86)\Adobe\Acrobat 9.0\Designer 8.2\EN\Samples\Forms

100

getField - Adobe LiveCycle

I have seen code examples using getFieldWanted to try it: So I have a field on my form called nYearBut when I use this codevar nYear = this.getField("nYear").value;I get the errorthis.getField is not a function2:XFA:myday[0]:Page1[0]:Button1[0]:clickAny ideas why?

1.4K

Re: Database connection and what is the best method - Adobe LiveCycle

Case solved, used data drop down lists from the custom object library and with slight mod in the code, have it all working just great.

140

Re: Windows 7 64 bit and ODBC connections - Adobe LiveCycle

64 bit drivers do NOT work, while the 32 bit drivers do.Took awhile, but finally got them doing what they need to do.

123

Re: 2 Drop downs to Filter Data - Adobe LiveCycle

Case closed - have it working. Look at the custom drop down lists and pull down a Data drop-down, the code needs work, but it works!

121

Jump code - Adobe LiveCycle

Is there a way to jump to another page if a button is clicked?ie: an index at the top and buttons to go to various parts of the form.

340

Re: Drop down with filtered ODBC data source - Adobe LiveCycle

Problem solved, was able to get 3 drop downs to work that filter the ODBC data that I needed.Solution was actually in the Custom object library "Data DropDownList"Had to make some code changes, but works!Oh yes, the other issue is I believe that there is a bug with the ODBC drivers for Windows 7 64 bit. I could only get the 32 bit drivers to work.

101

Drop down with filtered ODBC data source - Adobe LiveCycle

Does anyone have sample code that can show me how to link a drop down to a remote database tableie: I have a list of projects by year and I would like to have the drop down show me all projects for 1 specific year where more than 1 year is present.I am not sure which way to do this, read all the data in to an array, then filter based on the year;orHave the form allow you to select the year, then make the call to get the data for that 1 yearLooking for a good example so I can learn the process.Th...

649

Re: Windows 7 64 bit and ODBC connections - Adobe LiveCycle

Oh, interesting that the 64 bit ODBC works fine with Microsoft Access to link into the SQL database.I can see and update the tables fine.So, my first thought would be that LiveCycles has a problem on Windows 7 64 bit or some settings that I am not aware of that need to be set.

123

Re: Windows 7 64 bit and ODBC connections - Adobe LiveCycle

Anyone that you can ask at Adobe that may know about any such issues?

124

Re: Windows 7 64 bit and ODBC connections - Adobe LiveCycle

Hi PaulI am trying to get the 32 bit drives to work connected to a SQL remote database and I get the following errorGeneralError:Operation failed.......Index is out of boundsI am using a simple script to clone the datasource so a drop down can bring up the other row valuesThe lines that it is failing on iswhile(xfa.sourceSet.nodes.item(nIndex).name != "DataConnection2"){ nIndex++; }worked fine in Vista, but not windows 7 (using 32 bit drivers)Any suggestions?

124

Windows 7 64 bit and ODBC connections - Adobe LiveCycle

Curious, has anyone recently ported over to Windows 7 64 bit version from Vista and having ODBC issues?I have a very simple form that works fine on Vista 64, but when I connect with Windows 7 64 bit, it stops working.Looks like the 32 bit ODBC drivers work a little better, but not much.So questions:Does lifecycle work with windows 7 64 bit version?Do the 64 bit ODBC drivers work?Do the 32 bit drivers work?If issues, any threads out there?

1.9K

Drop Downs not reading data - Adobe LiveCycle

This is probably a very dumb question, but ...I have 2 forms, one is working great, reading from the database and showing the drop downs properlyThe other is set up the same way, started from a new form, but is not allowing any drop down interaction.Just shows the first record. and is greyed out.Question: What would cause this and where do I look to try and fix this?

450

Re: Database connection and what is the best method - Adobe LiveCycle

No errors reported.

140

Re: Database connection and what is the best method - Adobe LiveCycle

wrtAre the values that populate the DDlists in different tables or the same one? - Yes different onesIf they are in different tables then I think you will need a different data connection per table. I agree.If they are the same then you shodul be able to define the SQL statement that you want to run in the current code.I suggest that you use the exit event of the DDList and not the change event. - Will tryAt the moment, using a button to initiate the data source for the #2 dDown with the followi...

141

Re: Database connection and what is the best method - Adobe LiveCycle

Hi PaulFirst - thanks for the tips so far!Working on a project that requires 2 drop downs to filter the next third drop down.Need user to select ClientID and YearIDI have the code working for the first dropdown (ClientID), but unable to get the second drop down to show JUST the data related to the selected clientID.I am using these Data connections:Clients - providing the ClientID'sClientsDetail - Same as above but is the selected record from the first Drop down (ClientID)Years - providing the C...

141

Re: Joining 2 fields - Adobe LiveCycle

Hi, Using the arrays looks great for what I need to do too.But the data is hard coded and thus not as flexibleeg: you use var caCodeStr = "Canada,AB,BC,MB,NB,NL,NS,NT,NU,ON,PE,QC,SK,YT";If this data was in a relational database that I want to connect to One table with CountryID and CountryName and other dataAnother table with CountryID, StateID, StateName and other dataQuestion:How would I load the required data from these tables to populate the arrays?

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe