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

How To Save Modified Fields After query From The Database

Avatar

Level 2

I Have This Customer Information Form That's Sort of an Ordering Forms , I Made It By LiveCycle v9.0

And I Want To be able to search for Specific Record and Modify it and Save It Again to The DataBase

I believe That We All Saw The (( Data Connected Forms Presentation )) For Pual Guerette

At One Part Of The Presentation (Minute 0:26:00 specifically) When He Try To Search A Specific Record In the Database

And He Got all this annoying Messages Then The Record what He looking Shows up ; He Said That We No Longer able to Modify The Record After We Doing the Search

My First Question Is Why ???

Is there anyway After I got that Specific Record I Want from the Database I Can make my modification on it and update it Back in the DB.

OR i Have to Browse the whole DB looking for it Specially that I got this (ID Auto Increasment Number field Issue) Which leads me to ;

My Second Qustion;

Why I Can't just connect ''The Form Order Number'' to an Auto Increasment Number field in the DB

Obviously i can't, So Can I do Anything to achieve this goal ??


I Believe that we can Find some scripting to make that Happen 

I Will Be So Grateful If There Is Any Helpful Answer

FYI: I'm Not Java Expert So If There Is any Coding That's Can be Helpful Please POST ALL OF IT if you can ,,,,

5 Replies

Avatar

Level 2

Anybody Please ???

Even telling me if i cant do that

Avatar

Level 10

Hi,

You hould read Stefan Cameron's posts on databases. Just do a search on his site and there are some very good posts from 2006/2009: http://forms.stefcameron.com/.

Niall

Avatar

Level 2

OOOh Do i have to read all of that its very long period

Can just give the good stuff links ??

Avatar

Level 10

Hi,

The information there is excellent and I would strongly recommend it.

I don't have any public database examples and I am not inclined to spend time preparing an example if you are not prepared to read up on the methods.

Stefan's site is the only link I have for databases.

Good luck,

Niall

Avatar

Level 2

Thank u sir

I Just Want to mention that i read a lot of topics there

before i came here to ask my question but i can't found what I'm looking for

Thank u Anyway Niall