(1) how pb8 adding in the database stored procedure

Description: I'm in pb8, create a database in the object window, I built the database below Driver Information, Groups,
The Metadata Types, Procedures & amp; Functions provides, Tables, the Users, the Views of these folders,

Question: how can I get the Procedures & amp; Functions provides folder to add stored procedures?

In my Interactive SQL window (2) create a table, the table, please store the default? I can't find it?

(3) to create the student table, I have five student information, including student id, name, professional, accidentally the execute two insert into statements, table in a
Two groups of students of the same information, I use the delete row after deleting, again the select * from student; Why are there two groups or show?

CodePudding user response:

1. The

2. You need to submit, as the first point to refresh.

3. After you DELETE, no submit
//if the database is above in the drawing board, according to COMMIT
//if it is in the program, if it is to write code by hand, to add a COMMIT; If it is done in the DATAWINDOW operation to DW_1. The update () to COMMIT

CodePudding user response:

The first two problems are solved, thank you very much!
The third question, I can't find the commit this button,

CodePudding user response:

The first two problems are solved, thank you very much!
The third question, I can't find the commit this button,

reference 1st floor response:

1.

2. You need to submit, as the first point to refresh.

3. After you DELETE, no submit
//if the database is above in the drawing board, according to COMMIT
//if it is in the program, if it is to write code by hand, to add a COMMIT; If it is done in the DATAWINDOW operation to DW_1. The update () to COMMIT

CodePudding user response:

CodePudding user response:

The key in PB8 I call the save changes, and grey, not points,
Ready to introductory book and began to look, just this card on this issue for two days, want to get rid of as soon as possible,

The

reference 4 floor response:

CodePudding user response:

To be modified to SAVE changes. At the same time, your table has a primary key (to update PB) can be changed.

CodePudding user response:

Are all down,