{"id":2465,"date":"2014-12-22T23:10:13","date_gmt":"2014-12-22T23:10:13","guid":{"rendered":"https:\/\/alt2.minisoft.com\/support\/?p=2465"},"modified":"2016-12-19T04:59:08","modified_gmt":"2016-12-19T04:59:08","slug":"sybases-powerbuilder-5-0","status":"publish","type":"post","link":"https:\/\/c002.minisoft.com\/support\/sybases-powerbuilder-5-0\/","title":{"rendered":"Sybase’s PowerBuilder 5.0"},"content":{"rendered":"

Setting the Database Preferences<\/h2>\n

At this time, you must un-select the ‘Use Powersoft Repository’ checkbox in the Database Preferences dialog. This capability will be available with catalogues in a future release.<\/p>\n

    \n
      \n
    1. Select Database from the toolbar.<\/li>\n<\/ol>\n<\/ol>\n

      \"ODBC_p06\"<\/p>\n

        \n
          \n
        1. Uncheck the Use Powersoft Repository box.<\/li>\n<\/ol>\n<\/ol>\n

          \"ODBC_p01\"<\/p>\n

          \n

          Creating a new library<\/h2>\n

          1.<\/p>\n

          \"ODBC_p07\"<\/p>\n

          2.<\/p>\n

          \"ODBC_p08\"<\/p>\n

          3.<\/p>\n

          \"ODBC_p09\"<\/p>\n

          4.<\/p>\n

          \"ODBC_p10\"<\/p>\n

          5.<\/p>\n

          \"ODBC_p11\"<\/p>\n

           <\/p>\n

          \n

          Creating a new project<\/h2>\n

          \"ODBC_p12\"<\/p>\n

          \n

          To use your ODBC data source<\/p>\n

            \n
              \n
            1. \u00a0Add a new Database profile that references your ODBC data source.<\/li>\n<\/ol>\n<\/ol>\n

              \"ODBC_p02\"<\/p>\n

                \n
                  \n
                1. \u00a0Select the data source as your current Database Profile.<\/li>\n<\/ol>\n<\/ol>\n

                  \"ODBC_p03\"<\/p>\n

                    \n
                      \n
                    1. \u00a0Create a DataWindow.<\/li>\n<\/ol>\n<\/ol>\n

                      \"ODBC_p04\"<\/p>\n

                        \n
                          \n
                        1. \u00a0Select the fields you want to display.<\/li>\n<\/ol>\n<\/ol>\n

                          \"ODBC_p05\"<\/p>\n

                            \n
                          1. \u00a0Place the DataWindow on your form and write a script attached to a button to fill it.<\/li>\n<\/ol>\n

                            transaction abc<\/p>\n

                            abc=create transaction<\/p>\n

                            abc.dbms=’ODBC’<\/p>\n

                            abc.dbparm=”CONNECTSTRING=’DSN=MSDB’,
                            \nCONNECTOPTION=’SQL_DRIVER_CONNECT,SQL_DRIVER_
                            \nNOPROMPT'”<\/p>\n

                            connect using abc; dw_1.settransobject(abc)
                            \ndw_1.retrieve()
                            \nRunning this application should allow you to see your dataset.<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"

                            Setting the Database Preferences At this time, you must un-select the ‘Use Powersoft Repository’ checkbox in the Database Preferences dialog. This capability will be available with catalogues in a future release. Select Database from the toolbar. Uncheck the Use Powersoft Repository box. Creating a new library 1. 2. 3. 4. 5.   Creating a new […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2465"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2465"}],"version-history":[{"count":5,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2465\/revisions"}],"predecessor-version":[{"id":2482,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2465\/revisions\/2482"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2465"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2465"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2465"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}