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

cbprescott
cbprescott
Offline

Badges

Badges
6

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
11

Discussions

Discussions
0

Questions

Questions
3

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by cbprescott
Customize the badges you want to showcase on your profile
Re: Number of rows in a data view - Adobe LiveCycle 18-05-2009
Well not quite there.In the first table, 16b, in the attached file (rename .txt to .zip) column 1 is showing 'Empty' for all rows, even tough the correct value is being returned from the data table.The data for columns two and three of the pdf table are being retrieved correctly and populated correctly in the table, but column one is not, even though I appear to have everything correct.Do you have any clues as to why the data ifor column one is not being displayed correctly?Cheers,Chris

Views

303

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 14-05-2009
Brilliant - Stefan solutions worked.For those others who may view the this thread for LifeCycle Designer 8 you need top use.. var oDB = xfa.sourceSet.nodes.item(nIndex).clone(1);so that you can set the 'bofAction' & 'eofAction' attributes.I must say though that I haven't seen any mention of this anywhere.Thanks for your help.Chris

Views

303

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 13-05-2009
Okay, here is the 'txt' file.  Rename it back to '.zip'.Cheers,Chris

Views

304

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 13-05-2009
Nope no go. I'm trying to attach a zip gile with a pdf and an MS Access mdb file but it looks as though you don't accept a zip file. Here is the pdf but this is useless without the data. How can I send you the .mdb file?Unfortunately I'm on the other side of the world so to try and get more than one response a day is very difficult.Chris

Views

307

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 13-05-2009
My message got through but the attachment didn't so I'll try again.

Views

301

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 13-05-2009
That is what I feared. I've tried isEOF in a loop but it just kept on going. I then found that you needed to ...setAttribute("stayBOF", "bofAction") and ..setAttribute("stayEOF", "eofAction"). I added this but the code bombed on these lines and failed to set the bofAction and eofAction. That is the subject of another current discussion but unfortunately I haven't received any responses to that.So I've now put together a small pdf (attached) that shows what I'm trying to achieve (I hope) and the ...

Views

303

Likes

0

Replies

0
setAttribute("stayBOF", "bofAction") failing - Adobe LiveCycle 12-05-2009
Could someone please xplain to me why the following is not working...xfa.sourceSet.NRSP_Q16b.open(); xfa.sourceSet.NRSP_Q16b.first();var nDBIndex = 0;while(xfa.sourceSet.NRSP_Q16b.nodes.item(nDBIndex).className != "command"){nDBIndex++;}xfa.host.messageBox("nDBIndex = " + nDBIndex);// Backup the original settings before assigning BOF and EOF to stayvar sBOFBackup = xfa.sourceSet.NRSP_Q16b.nodes.item(nDBIndex).query.recordSet.getAttribute("bofAction");var sEOFBackup = xfa.sourceSet.NRSP_Q16b.node...

Views

588

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 12-05-2009
No, I'm talking about a data view in Life Cycle Designer. In the attached image I need to find out the number of rows in the remote table 'NRSP_Q4b'.Any clues?Thanks,Chris

Views

301

Likes

0

Replies

0
Re: Number of rows in a data view - Adobe LiveCycle 12-05-2009
Thanks for the reponse but I'm after the number of rows in the DATA VIEW, not a table in the pdf.Any clues,Chris

Views

305

Likes

0

Replies

0
Number of rows in a data view - Adobe LiveCycle 11-05-2009
Hi,I have a Data View that is linked to a table in an MS Access database.How can I determine the number of rows that are in the data view?Thanks,Chris

Views

2.4K

Likes

0

Replies

15