Managing the Database – PB Docs 126
Managing the Database About this chapter This chapter describes how to manage a database from within PowerBuilder. Contents Topic Working with database components Managing databases Using the Database painter Creating and deleting a SQL Anywhere database Working with tables Working with keys Working with indexes Working with database views Manipulating data Creating and executing SQL…
Entering SQL – PB Docs 126
Entering SQL You can enter a SQL statement in four ways: Pasting the statement Typing the statement in the view Opening a text file containing the SQL Dragging a procedure or function from the Objects view Pasting SQL You can paste SELECT, INSERT, UPDATE, and DELETE statements to the view. Depending on which kind of…
Creating and deleting a SQL Anywhere database – PB Docs 126
Creating and deleting a SQL Anywhere database In PowerBuilder you work within an existing database. With one exception, creating or deleting a database is an administrative task that is not performed directly in PowerBuilder. The one exception is that you can create and delete a local SQL Anywhere database from within PowerBuilder. For information about…
Working with database components – PB Docs 126
Working with database components A database is an electronic storage place for data. Databases are designed to ensure that data is valid and consistent and that it can be accessed, modified, and shared. A database management system (DBMS) governs the activities of a database and enforces rules that ensure data integrity. A relational DBMS stores…
Working with Databases – PB Docs 126
Working with Databases This part describes how to use PowerBuilder to manage your database and how to use the Data Pipeline painter to copy data from one database to another. Document get from Powerbuilder help Thank you for watching.
Using online help – PB Docs 126
Using online help PowerBuilder help contains the core PowerBuilder documents. Accessing help Table 1-8 lists the ways you can access help. Table 1-8: Accessing online help Approach What it does Use the help menu on the menu bar Displays the help contents, the What’s New in PowerBuilder help, or help for the current painter. In…
Defining a return type – PB Docs 126
Defining a return type Many functions perform some processing and then return a value. That value can be the result of the processing or a value that indicates whether the function executed successfully or not. To have your function return a value, you need to define its return type, which specifies the datatype of the…
Using the OLE 2.0 style – PB Docs 126
Using the OLE 2.0 style The OLE presentation style lets you link or embed an OLE object in a DataWindow object. For information about the OLE 2.0 presentation style, see Chapter 31, “Using OLE in a DataWindow Object .” Document get from Powerbuilder help Thank you for watching.
Aligning controls with each other – PB Docs 126
Aligning controls with each other You can align selected controls by their left, right, top, or bottom edges or their horizontal or vertical centers. PainterBars in the Window painter The Window painter has three PainterBars. PainterBar1 includes buttons that perform operations that are common to many painters, including save, cut, copy, paste, and close. PainterBar2…
About controls – PB Docs 126
About controls About window controls You place controls in a window to request and receive information from the user and to present information to the user. For a complete list of standard window controls, open a window in the Window painter and select Insert>Control. If you often use a control or set of controls with…