Search results

Osborne, this is also not working.. I am not assigning values to the variable or fields. I am just retrieving it and making a replacement on above criteria. So, I need to evaluate the existing values.

U tried that on Unix or Windows env? As I could think of, it might be due to Unix env. Or is there any way to make this work on Unix ?

I tried that too but it's not working :( , in actuals even the simple display is not correct. Output for above code is something like this: abc -- 'abc est1' xyz -- 'abc est1' Sorry, I forgot to mention env: OE 10.1C Unix

Hi All, I have a requirement where I need to replace "\" with "_" for all the occurrences in field or variable. def var abc as char initial "'abc\test1'". def var xyz as char. disp abc format "x(25)". xyz = replace(abc,"\","_"). disp xyz. This code doesn't recognize "\" in the variable...

Thanks for correcting me RHD . I am sure that compiler is more clever then me :)

Thanks for looking into this Tom... I don't care about this but I was just trying to understand that why it was picked that way. Anyhow, it doesn't bother me till the time I won't sort it and if required I will try to use use-index to explicitly specify index :)

Code I am Using : define variable l_ipfile as character. define variable l_count as integer. define temp-table tt_lddet field tt_site like ld_det.ld_site field tt_part like ld_det.ld_part field tt_loc like ld_det.ld_loc field tt_lot like ld_det.ld_lot field tt_ref like...

Thanks a lot for all of your valuable outputs.. I will provide the actual table, index definitions and actual query code by tomorrow for a better understanding.

Real Indexes are : pu ld_loc_p_lot u ld_part_lot and query picked ld_part_lot instead of ld_loc_p_lot I was expecting as per above scenario. @ RHD : I am totally agreed with your point that it doesn't matters because both are equally valid choice, But I just put this point for clearing some...

No Tom.. This is the only scenario. There are few more indexes on this table but i guess that should not to do anything with this. Also, I have a doubt over here that does sequence of fields does really matters while selecting an index because both indexes have same fields but with different...

Hi All, I am regular visitor of Progress Talk, a perfect place for Progress Technology related Knowledge and clarified most of my concepts from here. I faced a strange behaviour of Indexes with a query and so needs to share over here to get a good picture on that and to clarify myself on Index...

For +ve integer we can add up 0.49 instead of .50 and it will work with the solution as mentioned by Stefan and will work for all +ve integers: ROUND ( de + 0.49, 0 ) And for -ve integers just add 0.5 ROUND ( de + 0.5, 0 ) But yes, as mentioned by Tom, you have to evaluate separately for -ve...

You can use the INT to covert both time and can compare it. For ex.: INT(Time1), INT(time2) etc. This way you won't be changing anything onto DB but just evaluating the data as per your needs.

Also if we keep session 1 code as it is in my first comment ,then index error is displayed when second session is executed. As par my understanding , for the scenerio when Pause is after Delete , Since its in Do transaction block , Cust-num will not be reflected in DB as 999 untill the...

Just one correction in Session 1, Pause statement is after Delete Statement. Regards, Ravi

Hello Friend, I am facing locking error in when i execute second user session and i am not clear on conceptual side why progress disp lock condition occurs. The scenerio is geiven as below : Session 1 : DO TRANSACTION : Create Customer. Assign cust-num = 999. /* any non existing...

Thanks Dude..!! Might be oracle field need to be cross checked again. Thanks Stefan, This sounds fruitful in this scenario. So, if this is an issue because we are populating data in Progress Table through Oracle DB Tables. Is there anyway we can restrict on DB level, with some code-page or any...

Thanks for replying Dude. There is no initial value assigned for this field so it should be Blank (empty string)if nothing has been assigned to it. So my concern is: How ? has been entered into it because I doubt if it has something to do with Oracle DB putting data into this Progress DB Field...

Hi All, I have a small query regarding Unknown Value display in Character field. For ex: There is a field Phone format Char x(15). As per my understanding the default value in character filed in NULL i.e Blank. But, when i queries the field Phone it equals to ? rather then "?". And even if...

Hi Dude, ids means login ID and Passwords.