How To Save Modified Fields After query From The Database

[Abduzer]

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 ,,,,

[Abduzer]

Anybody Please ???

Even telling me if i cant do that

[Niall_O_Donovan]

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

[Abduzer]

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

Can just give the good stuff links ??

[Niall_O_Donovan]

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

[Abduzer]

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