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

BeavyB
BeavyB
Offline

Badges

Badges
4

Accepted Solutions

Accepted Solutions
0

Likes Received

Likes Received
0

Posts & Comments

Posts & Comments
9

Discussions

Discussions
0

Questions

Questions
1

Ideas

Ideas
0

Blog Posts

Blog Posts
0
Top badges earned by BeavyB
Customize the badges you want to showcase on your profile
Re: ODBC Connection with one to many results - Adobe LiveCycle 18-04-2011
Thanks Paul - I've sent them through - hopefully they will get to youRegards,Bev.

Views

323

Likes

0

Replies

0
Re: ODBC Connection with one to many results - Adobe LiveCycle 18-04-2011
Well we (and by that I mean ME) are no further along. I am using two MS Access tables. Can I email you the rubbish I have produced so far - you may laugh at your discretion!Regards,Bev.

Views

321

Likes

0

Replies

0
Re: ODBC Connection with one to many results - Adobe LiveCycle 18-04-2011
Hi Paul - I was wondering if I could pick this up with you again - I thought I could washmy grubby little hands of it all, but sadly no, I have to try and resolve the issue and any help would be very gratefully received.Regards,Bev.

Views

324

Likes

0

Replies

0
Re: ODBC Connection with one to many results - Adobe LiveCycle 14-03-2011
I give up! I really can't see what I am doing wrong - I really can't. It all looks like it should work but it blinking well doesn't - thanks for trying to help anyway Paul.Regards,Bev.

Views

319

Likes

0

Replies

0
Re: ODBC Connection with one to many results - Adobe LiveCycle 14-03-2011
Hi Paul - thanks again.Yes the query returns more than 1 result (in the example I keep trying it sould return 3 records)The repeat subform for each data item is also set.Do the settings in the ODBC properties need anything specific - e.g. delayed cursor - and what about the BOF Action and EOF Action settings (which I have to say I don't understand) - I am very self taught in Livecycle and boy does it show!Regards,Bev.

Views

318

Likes

0

Replies

0
Re: ODBC Connection with one to many results - Adobe LiveCycle 11-03-2011
Thanks Paul - I already have two data connections as there are two different result sets I am working onTo clairfy - the first data connection retrieves grant id, title name and address of all grantsThe second data connection then retrieves financial data for all projects related to those grantsThere are several records of financial data per grant.So the first bit of code retireves all relevant data for the grant selected.xfa.sourceSet.claimdata.#command.query.select = concat("SELECT grt_title, ...

Views

318

Likes

0

Replies

0
ODBC Connection with one to many results - Adobe LiveCycle 11-03-2011
Hi there - I have followed Stefan Cameron's excellent blogs on linking livecycle forms to data from an odbc connection however I have now become stuck.Effectively I have a form that populates part of the form with matching data for a specific id, however I then need to populate a different part of the form from another database connection that holds multiple records for that id.I have successfully completed the first part (YEAY!) however the second bit I cannot do - I have tried using the xfa.so...

Views

1.9K

Likes

0

Replies

11
How can I format a date field - Adobe LiveCycle 11-12-2009
Hi there - I have a date field called PjStartDate and I would like to ensure that the date entered always formats to DD MON YYYYHow can I do this as an exit event?The field is a date field and I have tried using display and edit patterns but they don't seem to work. I know I am probably doing something wrong - only just started learning livecycle!All help appreciated.Regards,Bev.

Views

538

Likes

0

Replies

1
Re: DATE VALIDATION dd/mm/yyyy (date field with manual entry) - Adobe LiveCycle 26-11-2009
Hi - did you ever get an answer for this - to prevent users from entering text into a date field and using ONLY the calendar? Regards,B.

Views

9.8K

Likes

0

Replies

1