PowerBuilder (PB) is a powerful development tool based on client/server architecture launched by PowerSoft Company (has been acquired by Sybase) and has been well received by developers since its inception. DataWindow is a patented technology in PB control, its data processing method is quite concise, data window can handle a variety of display formats, report printing, the same deal with complex nested reports freely.
The processing mechanism of a d
PB is a good development tool for database management systems, but PB is not very useful in Web and computer interface communication. Fortunately, we have Ole and COM technologies that make it easy for us to use the functions of some components
Client|oracle
Client-side approach to installing Oracle
Cantonese Zhongshan Thank you macro
2001/04/03
Objective:
I've seen a lot of people on the Internet asking the client to connect a PB program to an Oracle library by not installing
sample files are as follows (no DTD, just a simple example)
Copy Code code as follows:
My table structure, I think everyone's table should be designed like this
Order (sales orders, including
PowerBuilder is an enterprise-class database front-end application and multi-tier architecture development tool, user-friendly interface, powerful data window, is an integrated development environment.
Characteristics of PB
No matter how many years you have used a tool and how many books you have written, the technology is changing with each passing day. I think everyone is on the starting line.
The most common is for beginners. When they see a new technology, they
The sample file is as follows (without adding a DTD, for example, to describe it)
CopyCode The Code is as follows:
My table structure, I think everyone's tables should be designed in this way.Order (sales order, including
First, the type of window1. Main (main) window2. Popup (pop-up) window3. Child (Children) window4. Response (response) window5. MDI (multiple file interface) windowSecond, the properties of the window1. General tab: Determines the common
Remember, pay attention to three places.1. Open the datawindow window, click the data source icon, and first execute the table pop-up menu deselect all, then execute select all. In column specification of the data window, you can see that the field
When any data window is suddenly opened during use, the following error message is prompted, and then the Pb environment is closed directly:
Solution:
1.ProgramBack up one copy to prevent unexpected events
2. After the Pb is uninstalled, use
Transaction Object
We know that transaction objects play a very important role in the power BUILDER, and the power BUILDER applications must be connected to various databases through transaction objects, so before we discuss the relationship
Today's introduction to how PB connects SQL through a data source1. First to create a new data source, see the previous blog2. Locate oDB ODBC and select New profile3. Fill in the Profile name, select the data source we built, fill in the SQL
application design is not good, even if you use the compiled code, you will not get good system performance. In addition, adjusting the system parameter setting and reasonable physical bandwidth can make the application of PowerBuilder 5.0 run very quickly. In PowerBuilder 5.0, the system has been enhanced within a number of functions, to use these functions, in itself can achieve performance optimization.
concept, using PowerBuilder to develop distributed applications is very simple, as long as you use the PowerBuilder users from You can quickly grasp the development of distributed powerbuilder by defining objects that are not considered. In PowerBuilder, the functionality at one end of the application server is implem
1. Introduction
Since the advent of PowerBuild4.0, with its concise and efficient integrated development environment, powerful data window technology, (almost) omnipotent access to the database, more and more people are favored by programmers. According to Sybase's own statistics, there are currently 600,000 programmers and system analysts around the world using their PowerBuilder and s-designer for various types of application development. The latest
method:
First, define a cursor:
Declare cur cursorSelect "da_dh". "Hm"From "da_dh ";
Then you can:
String stxt [], StInt LiOpen curDo li = Li + 1Fetch curInto: stxt [Li];St = ST + stxt [Li] + "~ R ~ N"Loop while stxt [Li] Close cur;Mle_1.txt = ST
You can also use the second method:
Dw_1.settransobject (sqlca)Dw_1.retrieve ()
Use the PowerBuilder profiler tool to check. The time required for comparing the two methods is as follows:Time req
Format:
Integer dwcontrol. rowscopy (long startrow, long endrow, dwbuffer copybuffer, datawindow targetdw, long beforerow, dwbuffer targetbuffer)
Description:Dwcontrol The Name Of The datawindow control, datastore, or child datawindow from which you want to copy rows.Startrow the number of the first row you want to copy.Endrow the number of the last row you want to copy.Copybuffer a value of the dwbuffer enumerated data type (
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.