Search results

  1. P

    Sqlexp

    Which user are you using to run 'grant select, update, insert,delete on PUB."' + _file._file-name + '" to ~"dario" ' This user should be allow to do it (like Sysprogress) Patrice
  2. P

    Skipping An Unavailable Record

    Hi The error message seems to be on the FIND FIRST darwin.cupbackconv . You can add a no-error on it to avoid the message.
  3. P

    purge and resize db

    If you like adventure, complexity (not too much) , ... you could have a look at Nectar's breakout session at the last PUG on Online Dump-load . (The ZERO downtime Production Dump and load - PUG Challenge) It will allow you to: - Dump-Load on line - Change your RPB for each table - have small...
  4. P

    purge and resize db

    Sorry, I do not think it will work... The backup will restore each records in its current block number (it does not eliminate the empty blocks) You will have the same number of blocks in each areas (even if you could use different extent size or number ). If you run an idxbuild you will lost...
  5. P

    Question After Imaging Files

    If you enable the Audit Feature , you will probably have to increase the -L .
  6. P

    Auditing - Creating data for one table and not the other

    Hi I don't see the Audit-field in your xml. Patrice
  7. P

    Question How to increase decimal limit?

    format "->,>>>,>>9.99999"
  8. P

    OpenEdge enhancement request portal

    totally agree with Tom and Rob
  9. P

    how to connect visual studio (connect string c# ) on a remote aix 6.1 progress version 9.1a with only 4gl

    Hi Tom, They have to specify the -S XXXX to connect one of the broker If they specify "-S fbbj92-srv " for the 4GL connections and " -S fbbj92-srvsql " for the SQL connections , there is no mixed .
  10. P

    how to connect visual studio (connect string c# ) on a remote aix 6.1 progress version 9.1a with only 4gl

    I think it could work without the "-ServerType" (to avoid the "warning") , you always specify the good "-S " for your connection so they will be done on the good dedicated broker. "-S fbbj92-srv " for the 4GL connections and " -S fbbj92-srvsql " for the SQL connections ,
  11. P

    Lock Table overflow error

    Hi, I thought that on a "for each no-lock : create . ... end.", the transaction is "by default" for an iteration of the for each (1 record by transaction). If I am correct, to have a lock table overflow in this case , 3 options : 1/ the "for each" is fired in a transaction 2/ there is a...
  12. P

    Question Need to enable large file.

    You can use largefile with a size limit if you specify v + size, Example below is a limit of 2Gb for a variable BI b . v 2048000
  13. P

    Question Problem checking number of decimal places in excel via COM-Object

    Hi It seems that excel round the value with a precision of 4 degits. So you could try MESSAGE chExcel:Range("C5"):VALUE SKIP LENGTH(chExcel:Range("C5"):VALUE) SKIp Round(Decimal(chExcel:Range("C5"):VALUE) , 4 ) VIEW-AS ALERT-BOX. Patrice
  14. P

    Question Define trigger for all tables

    Hi, I assume this is the same as this post in the community ? https://community.progress.com/s/question/0D54Q0000ADfP36SQF/define-trigger-for-all-tables JP (João Pinto ?) , could you confirm ? If yes there is more information on what is expected. Patrice
  15. P

    Question Buffer copy

    You can also assign it directly in the buffer-copy create b-icsw. buffer-copy icsw to b-icsw Assign b-icsw.uniq_id = New-Uniq_id b-icsw.cono = XXXXX...
  16. P

    Resolved How do I to grant read only SQL access to ODBC user

    Do you specify the -H value on the sqlexp (the linux DB Server name)?
  17. P

    Resolved How do I to grant read only SQL access to ODBC user

    Hi , trying to connect to a linux DB from a Windows computer => Error establishing socket to host and port: localhost:#####. Reason: Connection refused: connect Do you specify the -H value on the sqlexp (the linux DB name)? Patrice
  18. P

    word index in temp-table

    Hi, Have you set a particular word-rules for your DB ? There is the parameter -ttwrdrul which sepcify the word-rules for the temp-table in your session . Patrice
  19. P

    Question How do i know its a valid directory and how i can know the handle belongs to a temp table

    FILE-INFO:FILE-NAME = cipDir . IF FILE-INFO:FULL-PATHNAME <> ? AND INDEX(FILE-INFO:FILE-TYPE, "D") > 0 THEN //The input directory is valid Else // The input directory is NOT valid
  20. P

    Question Ampersand befor open

    It rings me a bell when you use a browse in the UIB you could have {&OPEN-QUERY-BROWSE-2} Which is related to the browse browse-2 define several lines above in your code /* Definitions for BROWSE BROWSE-2 */ &Scoped-define FIELDS-IN-QUERY-BROWSE-2...
Top