(2) B (A key) C (1 candidate code)
2, PB is not only a built-in (), also can be applied to embedded SQL language directly manipulating database
A (PowerScript scripting language) B (custom function) C (predefined function)
3, the PB application object OPEN event is triggered when (),
A (executive) B (access database) C (compile application)
4, () function is to realize the program and database are independent of each other at the connection between
A (DBMS) B (ODBC) C (data sources)
5, ODBC database interface description file and the data source is in (),
A (dependent) B (independent) C (connected)
6, embedded SQL statements in the UPDATE statement is UPDATE condition of revolutionary drama () sets the updated,
A (the UPDATE (), B (WHERE clause) C (the SET clause)
7, PB built-in programming language filter according to () () function is set up by the retrieval condition is retrieved,
A (setSort (), B (setfilter (), C (WHERE clause)
8, () of dealing with the object of must be assigned before connecting to the database,
A (even the library feedback attribute) B (even the library property) C (communication attributes)
9, the data window object using the () to get the data from the database window operation data,
A (QUERY data source object) B (database tables) C (SELECT statement)
10, notify all applications can access to the database operation is () library communication,
A (application to window) B (2) C (1)
11, SQLCode belong to objects ();
A (even the library property) B (even the library feedback attribute) C (communication attributes)
12, the first library communication task code usually write the application object ()
A (Open) B (Close events)
Error checking by the 13, DBError events are usually occurs in the window object and () event,
A (Clicked) B (Open) C (Close events)
14, if we do not have the right to save in the data window have more lines of data and request to close the window, have the system immediately trigger
Window (code),
A (CloseQuery) B (DBError) C (Close)
15, PB application () to generate an executable program,
A dynamic link library) (B (object) C (engineering drawing)
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
1, according to the foot out of the window w_1 CloseQuery event code to fill in the blanks and answer the questions,
The Integer li_ret
IF dw_master. Modifiedcount () + dw_master. _______ () & gt; 0 then
Li_ret=messagebox (" attention!" , "whether the data has been changed, needs to be saved", & amp; Question! ,
Yesnocancel!)
Choose a case li_ret
Case 1 cb_update. __________ (clicked!
Case 2
Case 3 message.returnvalue=https://bbs.csdn.net/topics/1
//when the attribute returnvalue=https://bbs.csdn.net/topics/1, the original concept automatically cancel closes the window operation
The end choose
End the if
Fill in the blanks (1) :
I am grateful to 1, 2 ___________________
(2) to answer the question
<1> The operation of the trigger CloseQuery
A:
<2> The necessary condition to implement this code?
A:
2, if have a window in window w_1 rb_name radio button controls, it Clicked Event code is according to the
A certain name in a database table column "c_name" of the data window dw_master data sorting,
Please write the sort code and answer questions,
(1) write a sort of code
(2) to answer the question;
<1> Setsort () function?
<2> Sort function function
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
1. Please according to the principle of event triggers the relevant concept of short answer the following questions,
The function of (1) please state DBError event (check the types of errors)?
(2) according to what action triggering DBError events?
(3) the event to check error usually occurs in objects and events?
The function of (1) DBError event (to check the type of error);
A:
(2) the operation of the triggering event:
A:
(3) to check what error usually occurs in objects and events:
A:
2, please in this paper, the application of the communication object is the second time to access the database communication tasks and communication way of judging success?
(1) mission:
A:
(2) successful way of judging
A:
CodePudding user response:
A good dongdong, leave, for future examinationCodePudding user response:
I also come to aPB exam questions
1, what is the window or control of the message queue
Controls (including Windows) can respond to a series of different events, when more than one event occurs, these events will be according to the Trigger successively or Trigger ways (such as the Trigger, Post), set up a message queue to executed in sequence of events, the message queue in PB and VC in the message queue is the same, only is allowed in the VC explicit processing, the PB is basically automatic processing, but also set aside the second part of the interface, one is due to some of the ways, such as the close (), the open (), size (), etc., these basically corresponding to the VC's WM_CLOSE WM_CREATE message handler, WM_SIZE, and there is a custom, is to create a new event in the PB, then the event ID list, select an ID number, you can deal with the corresponding event,
2, what is the difference between Windows and controls?
Window is the main application communicate with the user interface, it can display system of related information, response to a user's mouse and keyboard input, etc. Control is the encapsulation of data and method, it can have its own attributes and methods, and properties are simple control data of visitors; Method is to control some of the simple and visible features,
3, what is the context?
An attribute of the orderly sequence, which the resides within the environment of the object definition environment, create context in the activation process of the object, the object is configured to require certain automatic services, such as synchronization, transactions, real-time activation, security, etc., multiple objects can be kept within a context, also have according to the context for understanding the meaning of meaning,
Context object describes the application execution context information, including the current version, whether in the PB environment window plug-in or ActiveX control operation, etc., using context information, you can modify the display information and application behavior,
4, what is the context service?
Was marked by the context object configuration corresponding synchronization, transactions, real-time activation, security, etc., and provides a corresponding software for its running environment,
5, under table when forgot to add the uniqueness of column specified, then find a mistake, would you like to go, and the results suggest there is a line or two is not the only, ask how do you know which two lines are not the only, make a mistake?
Create unique index to list all of the fields, to contain the same value obtained by abnormal rowid, then link the original table. Generate test table and test data,
6, what is inheritance? PB non-visual object implementation inheritance?
Inheritance is object-oriented a relationship between class and class, inheritance of class is called a subclass, the derived class, class 2 be inherited, call the parent class, the base class or super class, through inheritance, make a subclass has the same as the parent class of methods and properties, and subclasses can also add new properties and methods to establish or modify the properties and methods of the parent classes resume new class hierarchy,
PB can non visual object implementation inheritance, also can realize the corresponding code reuse,
7, PB in the custom object is the difference between visual and non visual object? Use of both objects need to declare?
Non-visual object is an object without a visual object of special processing, does not exist in this object is similar to the data window, buttons, list box for visual object, but it has its own data, and processing the data of functions and events, these data, functions and events can be considered to define the visual interface of an object, we through the interface to communicate with the visual objects, also can directly access the public data;
Visual object refers to any instance can be displayed on the stage (such as buttons, movie clips, Loader, UI controls, etc.), these are from DisplayObject derived subclass,
Visual objects don't need to declare, non visual object need to declare,
CodePudding user response:
Print a fixed line 8, Datawindow in each page, how to set up?
Add a computed column 1, the computed column must be in the Detail section, the input Expression: between (getrow ()/20)
Here can also use the global function instead of 20, such can allow the user to set any print how many rows per page,
2 defined group, select menu Rows - & gt; The Create Group... According to the calculated column groups, and certainly will check box - & gt; New Page On Group Break selected,
3 the computed columns set as invisible,
9, before you save the data, use the Update function to determine whether the data window usually has a primary key repeat data, if there are repeat is not allowed to submit, if we don't write a program to judge, can check data window itself, but the shows are in English, to this end, we are usually in the event of an DBError return 1 to block the message in English and then write the program for the primary key repeat judgment,
For primary key repeat judgment, realize a lot of methods, the efficiency high, introduced here is a kind of method of efficiency is very high, the idea of this method is that by filtering, data will display only once, in addition to if there is data in data after filtering window, then have duplicate data, how to implement the code?
String ls_fieldname
Long ll_rc
Ls_fieldname="dept_id"
Ll_rc=dw_1. RowCount ()
Dw_1. SetFilter (" ")
Dw_1. Filter ()
Dw_1. SetSort (ls_fieldname + "A")
Dw_1. Sort ()
Dw_1. SetFilter (ls_fieldname + "& lt;> "+ ls_fieldname + [1] or" GetRow ()=1 ")
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull