Search results

  1. mrobles

    Real Time Monitor Screen

    Hi I introduce code that use long time in the tick event and press the (X) and i recive the error. This program corrects the problem. It makes that if the tick event is working and you trie to stop the program, then send a message and reset the interval to cero. I use a variable to see if...
  2. mrobles

    Real Time Monitor Screen

    Hi Ian Maybe you are clossing the program while then tick event is executing. I'll revise the code. MRobles
  3. mrobles

    Progress v9.1b procopy error

    Hi Shut down the database or use PROBKUP online and then restore
  4. mrobles

    Real Time Monitor Screen

    Hi. This program give you a good example.
  5. mrobles

    Connecting to an Access Database

    Hi 1.- In control panel -> Administrative tools -> Data sources(ODBC) create a new Data Source Name (DSN) select Microsoft Access Driver. give it a name (suposse abc) and select the physical access database 2.- Create a progress database to be used as schema holder Connect to this...
  6. mrobles

    Real Time Monitor Screen

    Hi. Use the pstime control. You can change the interval chctrlframe-1:pstimer:interval = 60000. (miliseconds) It fires a tick event each minute. A cero value don't fire the tick event. Note: It's not real time.
  7. mrobles

    Dump Excel File Alingement

    Hi. chWorksheet:Range('A1:C1'):HorizontalAlignment = -4108. /* Center */ chWorksheet:Range('A2:C2'):HorizontalAlignment = -4131. /* Left */ chWorksheet:Range('A3:C3'):HorizontalAlignment = -4152. /* Right */
  8. mrobles

    To change the default Date Format

    Hi Put this in the first program SESSION:DATE-FORMAT = 'DMY'.
  9. mrobles

    Changing Excel Chart with Progress

    Hi Try this. chWorksheet:ChartObjects("Gráfico 1"):Activate. chExcelApplication:ActiveChart:Axes(2,1):MajorUnit = 1. chExcelApplication:ActiveChart:Axes(2,1):MaximumScale = 10. In my chart X axis is alphanumeric Y axis is numeric This example change Y axis Usually I use...
  10. mrobles

    Changing Excel Chart with Progress

    Hi. ChExcelApp:Charts("Chart1"):Axes(2):MajorUnit = 100. ChExcelApp:Charts("Chart1").Axes(2):MinimumScale = 10. And more... ..... MaximumScale = 120. ..... MinorUnit = 20. ..... MinimumScaleIsAuto = True. ..... MaximumScale = 5.55. ..... MinorUnitIsAuto = True. ..... MajorUnitIsAuto = True...
  11. mrobles

    passing parameters problem.

    Can you send the parameter in a file?
  12. mrobles

    Progress Equivilent of SQL

    /* Ex. 1.- Customers to change in a variable */ DEF VAR lista AS CHAR INITIAL '12345,12346,12347,14234,17423,12784'. FOR EACH customer_table. IF LOOKUP (STRING(custid),lista) > 0 THEN customer.slsno = "T23". END. /* Ex. 2.- Customers to change in a text file (one per row)*/ INPUT FROM lista.txt...
  13. mrobles

    How to run a progress session without DB

    You don´t have to be connected to a database to run a program in batch mode. Example: mbpro -p hello.p
  14. mrobles

    Help needed on COM-Handle.

    I always use this include file. (I made it) With this you can Open excel RUN abre_exel. Close comunications RUN cierra_excel. send data RUN pinta('text', reng, col). adjust to lansdscape RUN acuesta. change format, colors, borders, pagebreak, underline...
  15. mrobles

    Excel margin formatting slowed my report run time form a few minutes to over an hour.

    Re: Excel margin formatting slowed my report run time form a few minutes to over an h Hi. I Had the same problem. I used a sheet with a reduced left margin and every call to excel caused a great use of cpu by the spool manager (curious). Then, first fill the data then made the format. MRobles
  16. mrobles

    Unable to create r-code file - Error 477

    Do you have permissions in the target directory? Does the target directory exists?
  17. mrobles

    F1 Calls Progress Help no APPLHELP program

    Hi In Vista with Progress 91E, if I press the F1 key, then it calls the Progress help (help topics) instead the applhelp.p. Any idea? Thanks a lot.
  18. mrobles

    merant odbc

    Hi, I'm using Merant Odbc and Progress 9.1C I use this Odbc in Ms Access, some tables looks good but I can't retrive other tables. If I omit some fields then we see a correct result. Those omitted fields has the same Sql width in the format field. Do you have and idea? Thanks a lot.
  19. mrobles

    Refresh Browse Column Labels

    Hi First you need to save the initial labels of your browse Put this in definitios: DEF VAR etiquetas AS CHAR EXTENT 15 NO-UNDO. DEF VAR celda_br AS WIDGET-HANDLE EXTENT 15 NO-UNDO. DEF VAR cual_celda AS WIDGET-HANDLE NO-UNDO. DEF VAR n_cols_browse AS INT NO-UNDO. DEF VAR...
Back
Top