×
Discuss on Template programming, jBASE programming, Enquiries, No-File enquiry, Enquiry routines, Version, Version routines, Menus, Abbriviations, Creating local reference fields, Fast path enquiries, Creating charts and graphs, Generating Reports, Deal slips, Straight through processing, Multi Company and Multi Book setup, Tabbed screens, Composite Screens, T24 API, etc...
Execute SELECT and DELETE in TAFJ
- aldiyudha
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 8
- Thank you received: 0
5 years 11 months ago #21736
by aldiyudha
Execute SELECT and DELETE in TAFJ was created by aldiyudha
Hi,
I got problem when i used execute in routine.
This is my code:
EXECUTE "SELECT F.XXXXX WITH @ID LIKE ABC...20180509"
EXECUTE "DELETE F.XXXXX"
I want delete records that i got in select statement, in TAFC it works but in TAFJ it doesn't work.
Anyone has a solution for this issue?
Thank you.
Regards,
Aldi
I got problem when i used execute in routine.
This is my code:
EXECUTE "SELECT F.XXXXX WITH @ID LIKE ABC...20180509"
EXECUTE "DELETE F.XXXXX"
I want delete records that i got in select statement, in TAFC it works but in TAFJ it doesn't work.
Anyone has a solution for this issue?
Thank you.
Regards,
Aldi
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
5 years 11 months ago #21737
by VK
Cheers
VK
Replied by VK on topic Execute SELECT and DELETE in TAFJ
Hi
try to put a field mark between 2 commands and EXECUTE all it only once.
try to put a field mark between 2 commands and EXECUTE all it only once.
Cheers
VK
Please Log in or Create an account to join the conversation.
- aldiyudha
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 8
- Thank you received: 0
5 years 11 months ago #21738
by aldiyudha
Replied by aldiyudha on topic Execute SELECT and DELETE in TAFJ
Hi VK,
Thanks for your reply.
What's the meaning of put a field mark between 2 commands?
EXECUTE "SELECT F.XXXXX WITH @ID LIKE ABC...20180509 ID NAME DELETE F.XXXXX"
Like that?
Thanks for your reply.
What's the meaning of put a field mark between 2 commands?
EXECUTE "SELECT F.XXXXX WITH @ID LIKE ABC...20180509 ID NAME DELETE F.XXXXX"
Like that?
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
5 years 11 months ago - 5 years 11 months ago #21739
by VK
Cheers
VK
Replied by VK on topic Execute SELECT and DELETE in TAFJ
Hi
no, like that:
This helped in older TAFC releases where the second command did not inherit the result of the first one. Maybe it will also help in TAFJ (thankfully I don't have it so I can not try it).
Alternatively you can use RTNLIST option of EXECUTE statement.
P.S. Just remembered about EDELETE.
no, like that:
EXECUTE "SELECT F.XXXXX WITH @ID LIKE ABC...20180509" : @FM : "DELETE F.XXXXX"This helped in older TAFC releases where the second command did not inherit the result of the first one. Maybe it will also help in TAFJ (thankfully I don't have it so I can not try it).
Alternatively you can use RTNLIST option of EXECUTE statement.
P.S. Just remembered about EDELETE.
Cheers
VK
Last edit: 5 years 11 months ago by VK.
Please Log in or Create an account to join the conversation.
- aldiyudha
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 8
- Thank you received: 0
5 years 11 months ago #21741
by aldiyudha
Replied by aldiyudha on topic Execute SELECT and DELETE in TAFJ
Hi VK,
Execute with FM between two statement still doesn't work and RTNLIST doesn't work in TAFJ.
I never heard EDELETE. Can you give example?
Thank you.
Execute with FM between two statement still doesn't work and RTNLIST doesn't work in TAFJ.
I never heard EDELETE. Can you give example?
Thank you.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
5 years 11 months ago #21742
by VK
Cheers
VK
Replied by VK on topic Execute SELECT and DELETE in TAFJ
Hi
> RTNLIST doesn't work in TAFJ
Another reason to avoid it as long as possible...
> EDELETE. Can you give example
Something like:
> RTNLIST doesn't work in TAFJ
Another reason to avoid it as long as possible...
> EDELETE. Can you give example
Something like:
EDELETE F.LOCKING WITH @ID LIKE UNIQUE...Cheers
VK
Please Log in or Create an account to join the conversation.
- aldiyudha
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 8
- Thank you received: 0
5 years 11 months ago #21759
by aldiyudha
Replied by aldiyudha on topic Execute SELECT and DELETE in TAFJ
EDELETE and DELETE with condition still doesn't work. I think i've to use EB.READLIST then loop that list.
Thank you VK
Thank you VK
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G09-G13|TAFC:R05-R23|TAFJ:R19,R23:test
Less
More
- Posts: 1116
- Thank you received: 150
5 years 11 months ago #21760
by VK
Cheers
VK
Replied by VK on topic Execute SELECT and DELETE in TAFJ
Are you sure EB.READLIST still works in TAFJ? :)))
Cheers
VK
Please Log in or Create an account to join the conversation.
- aldiyudha
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 8
- Thank you received: 0
5 years 11 months ago #21762
by aldiyudha
Replied by aldiyudha on topic Execute SELECT and DELETE in TAFJ
Hahaha it still works, i've tried it. :)
I can loop that list then used F.DELETE but it will take more time.
I can loop that list then used F.DELETE but it will take more time.
Please Log in or Create an account to join the conversation.
- roshan zha
- Offline
- New Member
-
Less
More
- Posts: 6
- Thank you received: 0
5 years 11 months ago #21763
by roshan zha
Replied by roshan zha on topic Execute SELECT and DELETE in TAFJ
I think if u are working on TAFJ instead of using execute used eb.readlist it will work fine. mostly in tafj upgrade we have seen in document that if we are geting EXECUTE we were changing from execute to eb.readlist.
Please Log in or Create an account to join the conversation.
- roshan zha
- Offline
- New Member
-
Less
More
- Posts: 6
- Thank you received: 0
5 years 11 months ago #21764
by roshan zha
Replied by roshan zha on topic how to post a query on t24all.com
hello Everyone i need one help i dont know how to post a query on t24all.com am not getting any option to write a query. so atlast i thought i should ask over here. please someone can help me for this.
Please Log in or Create an account to join the conversation.
Time to create page: 0.131 seconds