Recent content by dev1

Same problems Hi, We had the same problems, users had sessions open, would select something and suddenly the whole session would close, no error messages nothing. After checking the db log file all we could find is error 794. We were on 9.1 and migrated through all the service packs and have...

Sorted. The code should be as below (i had the format statement before the screen-value statement): CREATE TEXT vh-label ASSIGN ROW = 3 COLUMN = 15 FRAME = FRAME {&frame-name}:HANDLE VISIBLE = TRUE format = "X(30)" SCREEN-VALUE = "Hello I am the side label" + ":" width-chars = 50. CREATE...

Hi there, I have created a dynamic fill-in with a label. However i cannot get all of the text in the side-label to appear. It seems to default to a format of eight, regardless of any other settings. Anyone have a clue where i am going wrong? /*Code*/ define variable vh-fill-in as handle...

Hi, We have recently moved a table which was replicated in 5 databases into a single one. A lot of the tables in each of the databases had indexes referencing a field in the table. Apart from this change, we haven't done anything else. Since the move there seems to be a degradation in...

Hi, I would like to know the name of any ocx's i can use to interface with digital cameras and progress to 1) capture photos 2) save photos to disk 3) print to required size (ie passport size). Does anyone have any starting points ? Thanks in advance. Winnt 4.0 Progress 9.1d sp5

Hi, Can't get into db's cos i forgot the sysprogress password. Can't get in as administrator, only as a user which doesn't have dba rights. How do i recover from this situation? Can i not somehow create relevant records in the _User _UserIO etc tables to recreate the sysprogress user...

Crittar, That hit the spot! Seems to sort out my probs. However, i just used the replace function, without looping, replace does this for me.

Hi i would like to know if the following is possible: define variable vc-add4 as character no-undo. define variable vc-pcode as character no-undo. assign vc-add4 = "Norfolk N15 7Bx" vc-pcode = "N15 7bx". I would like to search for the post code (vc-pcode) in the address line...

Yup, The same thing happened to me, i had a window open, with file menu items. I then opened a dialog box and appbuilder screwed up. When i closed the window i hit the save button and lost the code. It happened again, but this time i just closed the window down without saving anything...

Hi there, Using winnt 4.0, progress 9.1d05. I had a window with code behind menu triggers. When i saved program, all code behind the menu triggers disappeared ? Has anybody else experienced this? Is this a documented bug? Regards.

Easier? CCotter<Quote> You might find it easier to use ADO from Progress to read/update your Access database. I think its way harder to use ADO, simply because i haven't used much of it. The way i am accessing the MS Access db, i just use 'normal' progress statements, i can develop...

Sorted... The first problem was with autonumber in MS Access. When using create statement in Progress the Primary Key field was not assigned the next sequence number in the Access db. I was getting the last record of the table, assuming it would be arranged in PrimaryKey order, and thus the...

fixed Probs sorted.

Hi there, I have created an ODBC Dataserver schema to read records from a MS Access database. I use the create <table> command in progress to create records. However i have encountered a number of probs using this method. 1) The Autonumber is not incremented in Access, i need to input a...

I have come across 4GL's which have browses bound to the database, and moreover, they allow you to specify a number of records to be brought back in a single fetch of data. So if you had 20,000 records to read in, you specify 1000, the browse would then bring the first 100 records, when the...