Search results

Thanks for your reply Tom and Tamhas! So conclusively we should use strong scope with Find no-lock as well rather using a release statement. Is that correct ? Regards, Learner

Hi Boby, thanks for your reply! My point here is, with find no-lock statement (code at point 1) buffer still available after do block and as per my understanding it shouldn’t be available as we don’t need it. I want to know whether we should handle that or not (I think we should handle) if yes...

Hi All, hope you are doing well ! I know the use of Strong Scope with Exclusive-Lock but what should we do in case of find statements with no-lock. Example below: 1. Result is Yes. define variable lCheck as logical no-undo. if lCheck then do: find first table no-lock no-error. end. message...

Thanks @TomBascom and @Stefan. Yes, I missed and my answers was in Stefan’s statement.

Yes @Stefan , I want to compare two large objects, one is clob field of database table and second is a longchar variable. I tried using compare function also but that is also not working. Regards

Ok @Stefan , so how can we compare two large objects in Progress. I hope, there must be some way to do it. Regards.

Sorry, because initially I tried to do field to field comparison and then realize that field information in json is not static. Yes, getting this error message (even after typecasting CLOB to string()) and help is also not available for error 11420. Regards.

Thanks for your reply @Stefan , Actually I don't have static key/field information in JSON file. It can have multiple fields : values pairs of different tables. Requirement is to compare database CLOB field with longchar variable. Need to achieve something like below but it's not working: if...

Hello Guys, hope you all are doing well. I have a Longchar variable that contains JSON data of 4 fields. I want to write a query and compare these longchar variable values with DB table/fields. For Example: My Longchar variable contains below json data, I want to compare these JSON key : value...

Hi @Stefan , this code is working fine but Is there other way to get this handle in include file where we don’t want to copy “trigger procedure for delete of <tablename>“ in include file. Reason : There are/will be other logics also that refer trigger procedure block, we want to make our .i...

Thanks for your reply @Stefan . So In my delete trigger procedure only include file will be used: /* delete trigger .p of table */ { C:\Sports2\deletetrigger.i &table = test } /* deletetrigger.i */ TRIGGER PROCEDURE for delete of {&table}. run scankey ( ( buffer {&table}:handle ) )...

Hi @Stefan , could you please suggest how to use this handle in an include file. run scankey ( ( buffer customer:handle ) ). Regards,

Hi @Stefan , A Big Thanks to you for explaining me so many things. It was a very good learning for me as I was unnecessarily using dynamic query for the buffer which I already had. Thanks & Regards Again!

I was trying to access static buffer with below code : DEFINE VARIABLE vUniqueFields AS CHARACTER NO-UNDO. DEFINE VARIABLE vBufferValue AS CHARACTER NO-UNDO. DEFINE VARIABLE i AS INTEGER NO-UNDO. DEFINE VARIABLE fh AS HANDLE NO-UNDO. DEFINE VARIABLE h1 AS HANDLE NO-UNDO...

You meant, by passing the handle to different .p (genericdeletetrigger.p) and then using that handle to dynamically access the static buffer? I tried that also but I am not getting exactly what I need to do for that. Regarding Rowid attribute : I tried doing that also but it's not working as...

Hi Stefan, To answer this : although I have no idea why you want the rowid, since you already have the entire buffer I need rowid attached with handle because I want to dynamically extract field values of only Unique index fields not full record. Regards

find-by-rowid seems fulfilling the requirement, no need of long query-prepare, open, get-first etc. Only thing is we need to hardcode the table name in Rowid function. Regards.

Hi @Stefan , I am not able to understand what difference it creates after calling a separate procedure. I tired that as well. TRIGGER Procedure FOR Delete OF test. /* vTable = SUBSTRING(PROGRAM-NAME(1),INDEX(PROGRAM-NAME(1),"-") + 1, (INDEX(PROGRAM-NAME(1),".") -...

Sorry I am not getting this, If I am giving table name directly to ROWID function then also I am not able to get field values.

What should I do in this case, how to get specific values of static buffer (unique fields) dynamically. Please share your inputs on this. Regards.