Home
Forums
New posts
Search forums
What's new
New posts
New resources
Latest activity
Resources
Latest reviews
Search resources
Members
Registered members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
Registered members
Current visitors
Menu
Log in
Register
Install the app
Install
Home
Members
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
P
Progress_Learner
Member
·
33
Joined
May 29, 2019
Last seen
Today at 5:45 AM
Messages
97
Reaction score
3
Points
8
Find
Find content
Find all content by Progress_Learner
Find all threads by Progress_Learner
Latest activity
Postings
About
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
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...
Monday at 7:39 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
Thanks for your reply @Stefan . So In my delete trigger procedure only include file will be used: /* delete trigger .p of table */ {...
Monday at 4:38 AM
P
Progress_Learner
reacted to
Stefan's post
in the thread
ROWID on Dynamic Table
with
Like
.
Your trigger file: { deletetrigger.i customer } the include file // deletetrigger.i procedure trigger for delete of {1}: run...
Monday at 4:38 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
Hi @Stefan , could you please suggest how to use this handle in an include file. run scankey ( ( buffer customer:handle ) ). Regards,
Monday at 1:22 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
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...
Friday at 11:01 AM
P
Progress_Learner
reacted to
Stefan's post
in the thread
ROWID on Dynamic Table
with
Like
.
You will need to transform the static buffer to a buffer handle. Static means at compile time. So you will need a stub program per table...
Friday at 10:32 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
I was trying to access static buffer with below code : DEFINE VARIABLE vUniqueFields AS CHARACTER NO-UNDO. DEFINE VARIABLE...
Friday at 10:26 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
You meant, by passing the handle to different .p (genericdeletetrigger.p) and then using that handle to dynamically access the static...
Friday at 9:14 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
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...
Friday at 8:43 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
find-by-rowid seems fulfilling the requirement, no need of long query-prepare, open, get-first etc. Only thing is we need to hardcode...
Friday at 7:42 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
Hi @Stefan , I am not able to understand what difference it creates after calling a separate procedure. I tired that as well. TRIGGER...
Friday at 6:53 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
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.
Friday at 6:25 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
What should I do in this case, how to get specific values of static buffer (unique fields) dynamically. Please share your inputs on...
Friday at 5:30 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
"While you can create a dynamic buffer for the table, you do not have access to the static buffer used by the delete trigger." So this...
Friday at 5:22 AM
P
Progress_Learner
replied to the thread
ROWID on Dynamic Table
.
And Even after hardcoding the value I am not getting buffer values (coming as ?) whereas my query prepared well: CREATE BUFFER bh FOR...
Friday at 5:15 AM
Loading…
Loading…
Home
Members
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.
Accept
Learn more…
Top