1) The data dictionary : use SQLServer Desktop programs to create data dictionaries . The configuration is correct pbl File generation input list .
stay SQLServers In the querier select * from pbcatedt where pbe_name=' Dictionary name ',
Copy, append and paste data to Access Database pbcatedt At the end of the table .

2) Data sheet : use SQLServer The desktop program models the data table , Fields can be bound to data dictionaries , And create a data table .

3) Access database : Create data tables manually or through third-party software . But table fields must contain modeling fields .
And the name of the field 、 type 、 length 、 The decimal places must match the modeling fields .

4) ODBC Connect : Using data window designer , Create separate SQLServer and Access Database ODBC Connect .

5) Data window : Using data window designer , Connect SQLServer, Create card and tabular data windows .
This step enables the data window to attach the Chinese text label of the field and the sub data window .
The card is synchronized with the table data : The form is made of cards sql Statement to create .
card : The background is gray , Available fields with white background , Not available in grey .
form :Units Set to Powerbuilder(0), Use data window beautification tool to format .

6) Switch to connect to Access, If the data is extracted successfully, the creation is successful .

Datawindow.net+access More articles on how to make data windows

  1. PB In the existing datawindow How to add a data column in

    Open the data window , Click on Data Button Go to the data source definition palette , After selecting the column to add , Don't save files , Just click close , Just select Yes in the prompt box The new column value cannot be saved in the database , If you need to update the values in the database, then : Need to be in the data window palette , Click on ...

  2. pb Data window setting operation

    1 send DataWindow Columns can only be appended and cannot be modified DataWindow The data in can only be added to a new record and cannot be modified , utilize Column Of Protect Attributes can easily do this , The method is as follows : Put each column of Pro ...

  3. pb Notes of the data window settings

    1 send DataWindow Columns can only be appended and cannot be modified DataWindow The data in can only be added to a new record and cannot be modified , utilize Column Of Protect Attributes can easily do this , The method is as follows : Put each column of Pro ...

  4. PB9.0 Getting started with data window

    Because of work , Recently, the company uses PB More , At least 10 Not used in PB 了 , Review the data window usage .1. The code structure 2. Data window 3. Code window code APP Entry code 4. Need to use DataBase Insert a piece of data 5. perform ...

  5. [ turn ]MFC The sub thread updates the main window image display method after changing the image data

    The idea of the program is that the image signal is sent out by the external I / O control card , Then the camera collects the image and gets the image data pointer , The received image data pointer is created into an image and finally displayed to MFC Dialog application Picture Control Controls , meanwhile , In order to calibrate the camera position ...

  6. PB Methods to get or manipulate data window statements

    1.setsqlselect usage : ls_select=getsqlselect    // adopt getsqlselect Get the query statement of the current data window ls_where="  "    ...

  7. PB gird Type data window Set up groups 、 Group subtotal 、 total

    There's a need today ,gird The table data is as follows :   department   type data    A   type 1  1  A   type 2  2  B   type 1  3  B   type 2  4   total 10 The actual result to be displayed is :   department ...

  8. PB of use oracle The stored procedure returns the recordset as the data source to generate the data window ,PB This stored procedure will not be found and the parameters of the stored procedure will not be recognized properly ( turn )

    ( turn ) stay PB of use oracle The stored procedure returns the recordset as the data source to generate the data window First oracle The method of writing stored procedure is similar to MSSQL Dissimilarity , There's a big difference . If it's a stored procedure that returns a dataset, you need to use oracle To define cursors . ...

  9. Use DataGridView Data window control , Build a fast user input experience

    stay " Drift with the wind " In the blog , Introduced a good DataGridView Data window control <DataGridView Data window control development methods and source code to provide download >, This kind of control in some cases , also ...

Random recommendation

  1. solve vs collapse Unable to open project New project shows no constraints found

    Generally because windows Caused by update , Can be deleted with .net framework If there are too many patches, you can try the following methods : resolvent : 1. close VS: 2. Go to C:/Users/<your users ...

  2. solve ZBarSDK There is a garbled code in Chinese

    Use ZBarSDK The reason for the garbled code in the QR code interpretation is that ZBarSDK The wrong character set was used in the interpretation , Need to be in ZBarSDK Correction in the source code of . 1. You can go to http://sourceforge.net/p/zbar/_lis ...

  3. Cycle to get &lt;ul&gt; The value of the drop-down list . Contrast , The right home style

    $(function () { // The value to compare     var mysqlanswer = $("#wds-mysqlcuranswer").val(); // topic-opt ...

  4. C++ Middle template template &lt;typename T&gt;

    Recently in to see C++ Source code , There are many problems , Add little by little . The first is to meet template <typename Dtype>. There are so many explanations on the Internet , I think it's rather wordy , It's actually a type template . For example, we ...

  5. Zhu Ye's experience in Internet architecture practice S1E1:Pilot

    Zhu Ye's experience in Internet architecture practice S1E1:Pilot In recent years, there has been less blogging , When I was young, I was willing to write everything , Now, before I write something, I will think about whether it is valuable . I've been working for more than ten years , Did N Multiple Internet Systems , Business involves education . game . ...

  6. Nginx URL matching

      Nginx Next location modular   It can be realized on the web page URL Perform analytical processing location ~ .*\.(gif|jpg|jpeg|png|bmg|swf)$ { // extension gif|jpg|j ...

  7. Flink The broadcast variable of

    Flink Support broadcast variables , It's about broadcasting data to specific taskmanager On , Data stored in memory , This can slow down a lot of shuffle operation : For example, in data join Stage , Inevitably, a lot of shuff ...

  8. Advanced Javascript outlining Plug in description

    Advanced Javascript outlining plug-in unit purpose : stay js Write in file #region/#endregion Code snippet , Retractable and expandable . Similar to the background page region usage . The screenshot of the effect is as follows ( front ...

  9. 【 The fifth chapter 】 springboot + mybatis

    springboot Integrated springJDBC And JPA, But there's no integration mybatis, So I want to use mybatis We have to integrate ourselves . The integration is quite simple . 1. Project structure 2.pom.xml <!-- And number ...

  10. jenkins maven Set up settings.xml

    Environmental Science :jenkins.2.89.3 1. install settings.xml Management plug-in Config File Provider Plugin  System management -> Management plug-in -> Search for Config File P ...