Search results

  1. O

    Question Cross-reference In Browse Widget With Blocked Cells

    I need to create a cross-reference application in which the lines will be the colors and the columns will be the size of a particular textile product. The problem is that can not exist an item (SKU) for all the cells, and in these cases, I would like to block those cells to avoid improper...
  2. O

    Question Is There Any Way To Generate A Exe From Openedge?

    I would like to know if there any way to generate a *.EXE file for a Openedge program? We have the compiler that generates a *.r file, but we don´t have a kind of link-edition for this.
  3. O

    Question How To Locate And Download A File From Ftp Server?

    I´m needing a piece of Openedge code to locate a file on a Windows FTP server and download it in Windows platform. I can do it with Windows Explorer but I´d like to reference it commands like OS-COMMAND or OS-COPY. Thanks in advance for any help!
  4. O

    Question How Can I Execute Winrar In Openedge?

    I´m trying to execute de command: "RAR a zipfile sourcefile" using the OS-COMMAND, but I´m not managing because returns error messages, maybe I´m not using the correct sintaxe. Someone could help me?
  5. O

    Sintax for Excel Command Querytables

    I´m trying to import text file on Excel with "QueryTables" command but I´m having problem with "TextFileColumnDataTypes" parameter to define the fields types I´m listing below the command. Except for the last line the rest fo command is executing properly, but, imports characters fields...
  6. O

    Why the correct sintaxe for COM OpenText() Command with FieldInfo

    I´m trying to import data from text files to Excel and I need to define some columns as "text" others as "date", and son on, but, for one of the parameters (the 11º, FiledInfo) I´m not managing to adjust the syntax for OpenEdge COM Object. I listed below the command generated for Excel macro...
  7. O

    Lack of Resources in SQL Server Updating from Progress

    I´m updating MS SQL Server tables from a Progress application through ADO conection and it´s working for short ranges but when I try runs for bigger periods I receive a message about lack of resources (no more resources) or fails on data provider. I see the memory usage (in Windows Task...
  8. O

    Lack of Resources in SQL Server Updating from Progress

    I´m updating MS SQL Server tables from a Progress application through ADO conection and it´s working for short ranges but when I try runs for bigger periods I receive a message about lack of resources (no more resources) or fails on data provider. I see the memory usage (in Windows Task...
  9. O

    Record ID is larger than 245

    I´m updating some MS SQL tables with Openedge 10.1A Dataserver and, for a specific table whose primary key is formed by eight columns, i´m getting the error message "Record ID is larger than 245 (2090)" and the program is abborted. Some has faced this situation before?
  10. O

    ODBC (Access Denied)

    I´m facing the same problem with "Acess Denied" (7512) but on Openedge 10.1A, I have already created "SYSPROGRESS" user on Data Admin but in this version doesn´t have the SQL Explorer Tool anymore so, I´m not managing to give the GRANT privileges to the users. Someone knows what tool should I...
  11. O

    Process Excel Remains After Sheet Move

    I´m trying to move a worksheet originally opened from a CSV file to another workbook and than save it; everything is working but the Excel process remains in memory after application end. Follow the code used: DEF VAR chExcel AS COM-HANDLE NO-UNDO. DEF VAR chWBook AS COM-HANDLE...
  12. O

    Processe Excel remains active in Task Manager

    I wrote an application to populate a Excel spreadsheet and formatting them with Pivotable resource. It works (creates and save the workbooks correctly) but the Excel process remains active in Windows Task Manager. Bellow follows a extract of the Progress application: DEFINE VARIABLE...
  13. O

    MS-Excel Doens´t Reopen Query Wizard From Query Edit Option

    After a successfully querie built by the Query Wizard and a attempt to (re)edit the querie (from spreadsheet body), the MS-Excel doesn´t show the Query Wizard again but, on the contrary, shows MS-Query. I´d like to use Query Wizard because it is easier than MS Query from users point of view...
  14. O

    Exceding connections in SQL92 ODBC driver

    I´m having the following message when I try to connect the database from MS-Query: "[MERANT][ODBC PROGRESS driver] Driver´s SQLSetConnectAttr failed. [MERANT][ODBC PROGRESS driver] optional feature not implemented. [MERANT][ODBC PROGRESS driver] Exceding permissible number of connections."...
Top