Friday, July 30, 2010

PB How to get Crosstab column name


---- PowerBuilder was recognized by all, the best database front-end development tools, its unique, that is, the data window (DataWindow). It is the flexibility to organize the various data in the database, the user can use a simple query window can be a rich query results, and can be programmed on the query result set, all users come to the desired end result. If able to skillfully use the patented DataWindow technology developers and users will no doubt bring great convenience.
---- Crosstab is a kind of window data for statistical analysis of the data show style, the meaning of the Cross Tabulation, or horizontal tab. That it can retrieve data classification or grouping, to sum or average aggregate operation, etc., preparation of statistical tables.
---- However, developers using Crosstab data window will encounter a problem: If the developers want them out when processing the content, which can not be general method Crosstab column name, so that the operation can not run . This is because: Crosstab data window defined in the ranks of the data is different from the other window, and its columns are changing. So to get Crosstab column name must be used in other ways.
---- The following paragraph of a wage statistics of the number of statistics by gender were Crosstab DataWindow style as an example of the static obtained Crosstab column name.
---- 1, select the display style, define the data source, select the table "auths" columns "author_code", "salary" and "sex"; with the mouse to drag the Source Data list box of "sex" column to Columns list box, so that "sex" out into the longitudinal statistical data window column; use the mouse to drag the Source Data list box of "salary" column to the Rows list box, so that "salary" column as the horizontal statistics out the window of data , the salary to int (salary/100) * 100; with the mouse to drag the Source Data list box of "author_code" column to the list box to "count (author_code for Crosstab)" listed as the statistical value of the data window, At this point "CrossTab Definition" dialog box shown below: (Figure omitted)
---- 2, click the OK button, the data window as follows: (figure omitted)
---- 3, Crosstab DataWindow column names
---- Crosstab display style with static and dynamic. If using a static style, in the "CrossTab Definition" dialog box, uncheck the "Rebuild columns at runtime" checkbox. DataWindow column names in the Detail column, there are certain rules to follow:
---- The first column of the column birthright two situations: one, "CrossTab Definition" dialog box the selected Rows of columns named in the table fields, such as the Rows = salary is the first column of the listing as "salary"; two, such as "CrossTab Definition" dialog box the selected Rows of columns called computational expressions, such as int (salary/100) * 100, the first column of the column names are "row_column" .
---- The remaining columns were selected Value column names are arranged, such as the Value for the author_Code, then each column in turn "author_Code", "author_code_1", "author_code_2", ... ... the number of columns in the Columns are based on the selected The number can be generated, such as Columns = sex, only two columns "author_Code", "author_code_1";
---- The last column of the column named "grand_count_" + selected Value name, as in this case, "grand_count_author_code". Such as dynamic style in the "CrossTab Definition" dialog box, select the "Rebuild columns at runtime" checkbox. DataWindow column names in the Detail column: (Figure omitted) the first column and last column of column names similar to the static style described the situation, and not have a similar. The middle column of the listing of all the static style of a different situation, followed by the selected column names are arranged rows, such as the rows for the "salary", in this case, the columns were "salary", "salary_1";
---- So, the problem is welcome tough and understanding. In the Crosstab column names are also able to freely after the ranks of which the content processing. Through the above description, the reader can actually feel the computer is not easy to implement many of the functions, as long as the proper analysis, to digest, more tests several times, generally still able to find effective solutions.




Recommended links:



Gateway Bank of China has become the odds



To time TO modify unix password script, to prevent brute force



"Mirrors Edge" Cheats



format blackberry



Considerate: Foxmail 6.0 beta 3 the beginning of EXPERIENCE



Evaluate Animation Tools



mkv video format



Hot Browsers



Converting Mp3 To Aac



Who made the prosperity of reduced memory Zhongguancun



Special steps: maneuvers, decisive miles



Gateway Bank of China has become the odds



converter avi TO 3gp



Northwest Park Shanghai twists and Turns



New worm Floodnet (cute) little files



Evaluate Components And Libraries



Thursday, July 22, 2010

Ninth Zhongguancun Computer Festival was officially opened


Marked the development of high-tech industry matures Ninth Zhongguancun Computer Festival in September 5th, 2006 at Western Plaza, Zhongguancun, Haidian District, opened.

The unique design of the computer section of the opening ceremony for the five-day computer festival from the start to attract people's eye. Fully mobilize the opening of the advantages of the Zhongguancun Science Park and Zhongguancun Square resources environmental resources center on the "innovation, harmony and excellence" theme, cleverly combined with on-site environment, to create a science and technology, humanities, and harmony at the opening ceremony. Highlights the Zhongguancun is "source of independent innovation in China, the source of creative thinking, business insight fertile ground for" the subject.

The design of the opening of the full highlights of the Zhongguancun brainstorming and the front human wisdom. Zhongguancun high-tech advantage of resources implies a huge notebook rostrum, the whole venue seemed originality; green background with a green office simulation, extending the fertile soil of the open Zhongguancun business; main colors as blue screen, be conceived in Zhongguancun wisdom and hope that the sense of the times, means that the park's builders with the times and high-tech looking, highlighting the information age, rhythm, graceful Zhongguancun is more mature in her embrace of the idea to meet with dream of entrepreneurs.

The computer section of the opening ceremony starts clever use of props in the ENTER key notebook functions, the Zhongguancun Computer Festival and global information interaction perfectly articulated, in addition, another important prop launch is to build a notebook with crystal mouse, a symbol of the Zhongguancun information industry and the importance of transparency.

The opening scene has also joined the choreography of artistic effect. The "creative waterfall," the use, representing Zhongguancun is the "creative source"; is the Zhongguancun Hi-Tech Park to create a "high-end brands and creative industries, building high-end industrial clusters" of the performance of concrete.

Opening ceremony also simultaneously launched its second online Zhongguancun Computer Festival and the opening ceremony of the Zhongguancun who blog. Beijing Vice Mayor Zhao Fengtong attended the opening ceremony.

The opening ceremony is not only part of Haidian District, leaders of the organizing committee also invited from industry, academia, and research in such areas as part of the hundred entrepreneurs, technology experts and scholars as guests to participate in the Ninth Zhongguancun Computer Festival opening ceremony. Reflects the development of the Zhongguancun Science Park in the basis of its own high-tech, fully integrated its own resources and regional innovation resources, establish and improve collaborative research and development, the transformation of a combination of research mechanism. Embodies the enterprise-oriented "political", "production", "learning", "research" to share the experience leading technology innovation and the development of Zhongguancun builders of harmonious relations and the pursuit of excellence in the spirit of the Zhongguancun people.

The opening ceremony of the podium in front of the right side has also established a network broadcast station, Sina, Sohu, SAN FRANCISCO, Tencent, Zhongguancun online 5 on this prominent site at the same time the opening ceremony was webcast. Five sites to participate in online computer so that the second section shape.

Finally, the opening ceremony of colorful balloons in the air drifting over, a symbol of the future development of the Zhongguancun people hope and blessing, to create a harmonious development of the computer section of the healthy atmosphere.

This computer festival in the "innovation, harmony and excellence" theme focused around "Zhongguancun Innovation", "Zhongguancun creative" run through the computer section of this always, will establish the Zhongguancun creative industries and creative industries development of China's high-end image The Festival of the important purpose of the computer. In this section the most important computer is the enterprise-oriented, business and overall industry development as the core meaning of "Zhongguancun business." Haidian Zhongguancun is the start of the promised land, entrepreneurs home.

Computer section of the main activities this year are: Ninth Zhongguancun Computer Festival and the second section of the opening of online computer; two main forums: 1. Zhongguancun Development Forum - Innovation Forum, 2. Haidian International Venture Capital Forum; four parallel Forum: 1. innovation cluster and high-tech area Forum, 2. Zhongguancun creative forum, 3. software outsourcing and IT industry, International Cooperation Conference, 4. electronic environment of international standards and green procurement forums; Zhongguancun Radio, Film and Television Industry docking activities; Zhongguancun computer Festival Exhibition Fair - Digital convergence Carnival; "Win in China" entrepreneurial talent awards show; "creative, technology and life" cultural exhibitions and activities; Zhongguancun Computer Festival closing ceremony and signing investment activities.

The computer section for the first time this year developing a "high-end construction of cultural and creative industries - 2006 Radio, Film and Television Industry in China Zhongguancun docking activities." It is based enterprises in Zhongguancun, Haidian, do practical things for the company's specific portrayal of the computer section of the organizing committee is a bold and innovative attempt. Purpose built docking platform Zhongguancun creative industries, and do practical things for the enterprise; create Zhongguancun creative industries, film and television products, new market channels; Build Zhongguancun creative industry chain, build cultural and creative industries, high-end image, the formation of the Zhongguancun creative industries cluster.

Ninth Zhongguancun Computer Festival Exhibition Fair - Carnival has been fully digital convergence market operation, the carnival this year, digital convergence and sub-site with the main venue in the form of linkage. The main venue is located in the Haidian Exhibition Hall; theme: "Technology Development Creative - Digital Entertainment to change the life." Sub-site distribution in the core area of Zhongguancun electronic mall seven. As will be fully demonstrated China's electronic trading center in Zhongguancun area status.

This computer is also a colorful festival of cultural events. "Win in China" entrepreneurship, awards show and the "creativity, technology, life," cultural presentations, will be displayed fully independent innovation of enterprises in Zhongguancun style, brand culture to create the image of corporate culture.

Ninth Zhongguancun Computer Festival highlights three characteristics: First, the "political", "production", "learning", "research" of the innovation system of Zhongguancun new ways, the new model; common witness to the harmony and excellence in Zhongguancun ; Dramas Zhongguancun investment results. Second, the introduction of the "Zhongguancun Innovation", "Zhongguancun creative", "Zhongguancun business" concept, the establishment of the Zhongguancun creative industries content. All of these are enterprise-oriented, do solid work for the company for businesses seeking development opportunities, and create conditions for development, research results show business, the use of research and development technology park companies, enterprises have become the protagonist of Zhongguancun Computer Festival. Third, the Zhongguancun Computer Festival has taken shape in the market, international. Zhongguancun Computer Festival's overall activity is collected through social open market operation results. Chinese and foreign guests gathered in the computer section, the formation of many activities of the international landscape. Zhongguancun Computer Festival has become the international computer festival.






Recommended links:



C + + programmers to Easily commit the error of 10 C #



AlltoDVD DVD to MPEG



Apolo RM Converter



avi to iphone



MSVIDEO



Mp3 To 3g2



converter flv To 3gp



From "Made in China" to "Created in China"



Professional VCD SVCD DVD To IPod



Apex Apple TV Video Converter



News about Web Development



Open 3GP Converter



Terminal And Telnet Clients introduction



HAPPINESS CD-R M4P Midi to AC3 Manager



introduction Games CARD



Wednesday, July 7, 2010

Moyea YouTube to Apple TV Converter

Moyea YouTube to Apple TV Converter is a powerful tool to make your favorite YouTube videos sharing at home simple and easy. With this converter software you can convert them to Apple TV compatible file formats, such as MP4 (MPEG-4), MP3, M4A, AAC and WAV with customized video and audio effects, such as brightness, contrast, volume, cropping video, trimming video, etc. You can synch the output videos to Apple TV with iTunes, and connect Apple TV to a television or other video equipment through either HDMI or component video connections. Then the sharing of YouTube videos on a widescreen TV in a cozy room is possible.

Relax and content yourself with YouTube videos playing on TV, and put yourself at the realm of your entertain life. Moyea YouTube to Apple TV converter will always shift the YouTube excellence: movies, TV shows, music to your entertainment center.




Recommand Link:



Compare Accounting And Finance



ColeSoft DVD Ripper Platinum



Hot Java And JavaScript



FOR you Clocks And Alarms



Movavi Zune VIDEO Converter



APPLE tv



Youtube to Mobile PHONE Tools



Flv to mov converter



Cucusoft iPod Video Converter + DVD to i



Bliss RM CD to MP3 ID3 Tag Burner



Audio File Converter



Christmasgift DVD Manager



flv to AVI



Monday, July 5, 2010

Jason DVD to Pocket PC Converter

DVD to Pocket PC Converter is all-in-one professional mp4 converter software .it design for anyone who wants to enjoy DVD movies on the Pocket PC Player..With DVD to Pocket PC Converter, you are able to convert all favorite movies into your portable video device and watch them wherever and whenever you want. is it cool? yes! portability ages is coming!
DVD to Pocket PC Converter is able to convert almost DVD to Pocket PC files etc. . It contain H.264 and Xvid decoder to help you convert it with quick speed and hight quality. It also support select subtitle and Audio Tack to Export. It is a really smart software that just four clicks completes the task of video conversion. (1)Open DVD, (2)Select Output Type,(3)Select Destination, (4)Press Start ! it automatically detects your hardware configuration and decide an optimized conversion scheme. It also supports Automatically Shut down your computer after the conversion had done. it means you can just go to sleep ,let your computer do all the jobs and automatically shutdown when all jobs are done.