Search results

  1. pivert

    Answered deploy new client 11.2 via msi

    Thanks for the tips and I'll talk to our software provider to go to 11.3 or later. I've posted it on the deployment forum.
  2. pivert

    Answered deploy new client 11.2 via msi

    Does anyone know how to put the oe11.2 client in a .msi so we can use System Center to deploy it to the clients? I've read different articles to do it via silent install but for some strange reason SCCM refuses to install it. I've put everything in a bat-file with the silent install params and...
  3. pivert

    Question dump and load to test database

    There was a difference in areas so I've changed the .st file accordingly and I was able to restore it. Thx for the tip. I don't mind overwriting the test db (after checking with everyone, something we try to do once every year) but now it seems our test is of a more recent version than our...
  4. pivert

    Question dump and load to test database

    thx for the reply. I thought obu was an universal acronym for "online backup" in the Progress-world :-)
  5. pivert

    Question dump and load to test database

    progress 11.2 I have an obu from our live-db that I'd like to restore in our test-database. Our live db has a different structure so a simple prorest didn't work (or at least I couldn't figure out how) so I restored the obu in a temporary copy and did a dump of all files. Is there a way to...
  6. pivert

    Question to_date()

    Solved it. This sql goes through the whole WHERE statement. I added a CASE (see below) CASE WHEN LENGTH(datedc) = 10 THEN to_date( to_char(substr(datedc,7,4)) + '-' + to_char(substr(datedc,4,2)) + '-' + to_char(substr(datedc,1,2))) END > add_months(sysdate - dayofmonth(sysdate) ,-2) I...
  7. pivert

    Question to_date()

    I have a date-value in a characterfield, European style so it's "DD/MM/YYYY" with leading zeroes if needed. But I can't get my sql-statement working (sql statement is processed by an asp.net odbc program for small ad-hoc reports). I've tried several options (part of the WHERE-clause)...
  8. pivert

    set custom title in taskbar

    It was easier than that: SET CURRENT-WINDOW:TITLE = "test title". I didn't expect it to work for batch programs also but apparently it also sets the title on the Progress-task in the taskbar. We also changed all bat-files to use the dos-commands "title" and "start" so thanks for all the tips!
  9. pivert

    Cost of Lisensing

    @tamhas: we have 50 concurrent licenses extra, not short. We've pulled a stat over several years and we're having around 200 concurrent users but 250 licenses. But that's no problem since we expect extra growth in Russia. The extra 50 were purchased when there were some take-overs but shortly...
  10. pivert

    Cost of Lisensing

    Hi Tamhas, we are currently on 10.2b and our Progress partner does a license check every year, maintenance is paid every year. We're still on concurrent user but even then we are still about 50 licenses above that. And yes, I know :) but I have a small site of about 60 users running on windows...
  11. pivert

    set custom title in taskbar

    nope, tried it with different parameters but taskbar keeps saying "progress"
  12. pivert

    set custom title in taskbar

    I'm running a windows server only used for batch jobs. And sometimes, several progress jobs are running at the same time. Is there a way to set a custom title for a progress program? Now it just says "progress". The batch programs are started via a bat-file and here we use the "title" command to...
  13. pivert

    Cost of Lisensing

    I wanted to switch from unix to windows but at an "administrative cost" of 250 euro / user and having about 200 users... I guess they still engrave each license in Italian marble. And I'm still on unix.
  14. pivert

    Query object question

    thanks for the preselect-hint. had same problem!
  15. pivert

    Date validation on screen

    ? works, I forgot to re-display the field so I think the wrong (old) value keeps triggering the validation. It works now, thanks.
  16. pivert

    Date validation on screen

    I have a date-field on a screen. You can leave it blank, in which case it just displays " / / ". But once you enter a date, leave the field, come back and clear the date, you get stuck in the date-validation routine (the month of a date must be from 1 to 12). Is there a way to reset the...
Top