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...
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
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 , 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.