Data Windows is one of the most powerful features of PB. DataWindow is a control for obtaining patented technology in PB. It is quite simple to process the processing method of data and can handle various display formats and fast report production capabilities. Deeply loved by PB developers. But a product is not perfect, and DataWindow has many shortcomings, with some changes to the data sheet associated with DataWindow, may enroll a hard-working data, maintain the interface, and the report is re-made, especially Complex Chinese-style reports are a headache for many developers, and such problems will not exist in other development languages such as Delphi.
Now use a lot of development of the prototype model, making the modifications in the development of the developments become more common, in order to resolve the required reports, the main body of the data interface does not have to be done, and some solutions are put forward, I hope to encounter such problems. Developers are helpful, and they also hope to play the role of throwing jade.
1. Problem 1: The field of the table is increased or decreased.
This problem is relatively easy to solve. The field of the table, open the DataWindow window, click the Data Source icon, select the new field in the Selection List of the DataWindow window, and then the new field will be addressed in the original DataWindow window, but it is worth reminding. If you add a field in the input data DataWindow, remember to select the new field in the Updateable Column list in the Updateable Columns list, otherwise the new field value cannot be submitted; the field is deleted, open the DataWindow window, click the Data Source icon, First execute the pop-up menu Seselect all, then execute the SELECT ALL.
2, question 2: Modification of data length in the field in the table
Open the DataWindow window, click the Data Source icon, first execute the pop-up menu Select All of the table, and then perform the Select All to see the field of the modified length in the Column Specification of the Data Window is a new length. However, don't worry, for the field of the character type, the problem is not fully resolved, select the character type field of the modified length, right-click, select Properties, select the value of the limit in the EDIT property is the new length value, and the problem is resolved.
3, question 3: Modification of data type in the field in the table
Open the DataWindow window, click the Data Source icon, first execute the pop-up menu Select All, and then execute the SELECT ALL.
4. Question 4: The name of the table changes the field constant
4.1 Click the library library panel, select the data window or report you want to modify.
4.2 Right click on the mouse to select the pop-up menu item EXPORT, or select the ENTRY menu of the EXPORT item to make a data window or report to the .srd file, the file name defaults to the name of the data window or report.
4.3 Select the Edit icon in the PowerBar toolbar to open the original file.
4.4 Using the Replace Replace button in File Editor, replace all of the old table name strings in the modified file into a new table name and save it.
4.5 Select the Import item of the Entry menu, import the original files, overwrite the original data window or report, and solve the problem.
For problems 4, if the original data window has retrieve arguments and WHERE clauses, you should delete them, you can do it again, otherwise the conversion will fail, using the PREVIWE will report "SELECT Error Invalid column name" SELECT Error "using the data window . After the conversion is successful, then manually increase the retrieval parameters and the WHERE clause. For some changes in a slightly complex table, it can be solved by the above method. If you change the table name, the field is added and the original field length is modified, the resolution step can be: first built with the original table is only a different table name, and then use method 4; in the excessive table Field, then use method 1; modify certain fields in the excess table form a new table, and finally use method 2, problem solving.
I use the above ways in the MIS system in the PB development, which can be used quickly to reuse the reports and data maintenance windows in the development prototype, but it is worth reminding everyone that it is best to use the above method to back up the original data window. Prevent errors destroy reports and data maintenance windows.
