Ultradev example tutorial: 3.4 adds a record to the database

The 3rd chapter: Applied database founds dynamic webpage

The 4th: Add a record to the database

When the database does not have a record in front for the convenience of the test we operate a database directly, to inside added a few data. The content below is the page that teachs everybody to make submit data, such we can add data through the browser. This is more popular Browser-server mode. *_ "

Good, let us begin!

The first pace: Open Ultradev---Ah, gibberish.

Open menu Insert ->LiveObjects ->Record Insertion Form, following plan institute show:



After pitch on, give the inserts data to express odd attribute dialog box of now face.


Connection is the database join that we had defined in the site, after pitch on, in Insert Into Table the watch in database of your place connective can appearing in one column, choose you to want to insert the watch of data again from which. Our database has an Userinfo list only, pitch on he. The field that we can appear to had been designed in expressing a design in catching the Form Fields below reachs his relevant attribute, column states the database expresses medium field name, display As expresses to use why to plant the region expressing sheet of the type, for instance text expresses only region (Text Field) the record that will refer us, submit As expresses why to be planted data type will refer, we cannot use the field that is integral sex according to the type than exactly the amount text data type undertakes referring. General Ultradev can help this one column we choose automatically. Label help the content that hints you express only region this to fill in. After Inserting, one column of Go To is to become you to refer data to jump the meaning that turns to that page to go, turn to one page than jumping like the metropolis after registering a success commonly, tell you you had registered a success, what does the welcome use of what, be this appearance. If whats are filled this page is returned after expressing to submit data.

Next, choose the field that we should have data is added. Here, ID is automatic number, generate automatically by the database, so, need not we undertake operating to him, pitch on this group, click that to have " - " pushbutton, delete him. Reg_date field we gifted when the database is designed =Now() of his acquiescent value, also can the database is generated automatically, also need not we intervene, also delete so. Next we repair Label instead Chinese again, such one adds data to express sheet to had been done, see figure below:

 
After clicking OK, generate following plan institute to show a page. Wow! Be very ripe eye? Ha, a simple user registered a page to be finished, so Easy! If you have interest, can read the code that Ultradev generates for us, long!



Oh, did not forget to still a place wants to be installed, the attribute of the region that express sheet that is user code part, want the Type setting him to be Password, pursue as follows. Such, when inputting a password just won't proclaimed in writing is shown come, be replaced however with * .



Save a page, let us have a try immediately next our achievement, open a browser, input address, fill some of data to go in casually again, see figure below:



Click Insert Record to submit data, jump next the page that turns to indication data, ha, saw, we just are defeated by the data that go in to lie darlingly over. Those who believe you experienced Ultradev again is powerful, need to use a mouse a few times only, the page with a whole function came out, if use manuscript word to still do not know to want to write,arrive when, still get ceaseless test.



Actually, this registers a function or do not perfect, how to do with reduplicative data input for instance? Was the user that should some content fill filled however how to do again? These problems leave the Ultradev from the back retell of advanced use guideline, friends wait a bit patiently for the moment.

Good, next time we will be told about how to compile the record inside the database. Be, in case I am defeated by a fault not carefully how does data do, do not change how to go. As to how to accomplish this a little bit, and listen to next answering to decompose.