Search results

  1. L

    understanding bi

    afternoon all, we have a tiny db (about 3mb) that is comprised of 3 tables. daily we delete the records out of 2 of the tables and reload new data. when this is done the bi file grows quite large (as in more than 2 times the size of the db):confused: previously the tables were in another db and...
  2. L

    DST Calculating

    afternoon all, does anyone have a program that calculates if it is dst or not? or an example of calculating if it is the 2nd sunday of a month? thanks in advance. regards, longhair
  3. L

    Suggestions to improve code

    morning all, hpux 11i progress 9.1c i have a single user db with 2 tables that are wiped and repopulated everyday. for the wipe i do: def var i as int no-undo. outer_loop: do for db.table while true transaction: for each db.table exclusive-lock: delete db.table. i = i + 1. if i modulo...
  4. L

    bi file growth

    afternoonall, progress 9.1c hpux 11i i have a db with 3 tables. 2 of which get wiped and repopulated at least once a day. db size is about 3mb. whenever i delete the data from the table and create the new records bi file size grows to 6mb. any suggestions on the below code, or db settings that...
  5. L

    single user db

    afternoon all, quick question, for a db in single user mode is it normal to have a physical redo phase for each session recorded in the .lg file? thanks in advance. regards, longhair
  6. L

    bi size - is this odd?

    good morning all, quick question. hpux 11.i progress 9.1c. have a single user db with 3 tables. db size is about 3mb. everyday i delete the records in 2 of the tables and add in a new set of records. basically like this: for each db.table: delete db.table. end. input from /files/filename.txt...
  7. L

    Import requires data source other...

    I think this is just a Progress quirk - but want to see if anyone has any suggestions. I'm receiving this error message on a program that only pulls data from a file, updates or creates some records in a table and writes out log messages to another file. ** IMPORT requires a data source other...
  8. L

    button issue

    afternoon all, have a small issue that i don't understand. would think that the below code would work fine but it is not. any suggestions would be greatly appreciated. code snippet below. def z1 as int. def button btn-exit label " Exit ". def button btn-both label "...
  9. L

    Date / Time Question

    does progress have anything akin to the 'now' function in vb / vba?:confused: 'now' will display date & time (dd/mm/ccyy hh:mm AM) for example. anything native to progress or do we just need to string the date and time together (x = string(today) + " " + string(time,"hh:mm"). thanks in advance...
  10. L

    Cycle Count Printing

    afternoon all, syteline 6.01 progress 9.1c trying to print cycle count sheets (on a newly rebuilt pc). we print out to letter size paper, on hp laserjets - landscape orientation. we are using the hp 2300 5pcl e driver at a 90% ratio. in the past this has worked (but it might have been a...
  11. L

    compile errors

    afternoonall, any suggestions would be greatly appreciated. progress 9.1c hpux 11 attempting to generate a file with the proper headings to accept font / formatting commands that word pad will understand but the following code is producing errors: put...
  12. L

    File Date & Time

    morning all, progress 9.1c hpux 11 is there a command within progress to get an external file's date and time stamp or do i need to use os-command? thanks in advance. regards, longhair
  13. L

    Unexpected Value

    morning all, hopefully, one of the gurus can point me in the correct direction. i'm writing what i thought would be a simple script - read in from a print file and based upon information on a line output to one of 2 different files. the issue is that i never see the var 'y' increment - but...
Top