Forum
Keyword
× 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
  • aldiyudha's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 0

aldiyudha created the topic: Execute SELECT and DELETE in TAFJ

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
#21736

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Away
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 532
  • Karma: 9
  • Thank you received: 77

VK replied the topic: Execute SELECT and DELETE in TAFJ

Hi
try to put a field mark between 2 commands and EXECUTE all it only once.

Cheers
VK
#21737

Please Log in or Create an account to join the conversation.

  • aldiyudha
  • aldiyudha's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 0

aldiyudha replied the 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?
#21738

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Away
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 532
  • Karma: 9
  • Thank you received: 77

VK replied the topic: Execute SELECT and DELETE in TAFJ

Hi
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
#21739

Please Log in or Create an account to join the conversation.

  • aldiyudha
  • aldiyudha's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 0

aldiyudha replied the 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.
#21741

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Away
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 532
  • Karma: 9
  • Thank you received: 77

VK replied the 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:
EDELETE F.LOCKING WITH @ID LIKE UNIQUE...

Cheers
VK
#21742

Please Log in or Create an account to join the conversation.

  • aldiyudha
  • aldiyudha's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 0

aldiyudha replied the 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
#21759

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Away
  • Platinum Member
  • Platinum Member
  • R13|TAFC|jBASE|windoze
  • Posts: 532
  • Karma: 9
  • Thank you received: 77

VK replied the topic: Execute SELECT and DELETE in TAFJ

Are you sure EB.READLIST still works in TAFJ? :)))

Cheers
VK
#21760

Please Log in or Create an account to join the conversation.

  • aldiyudha
  • aldiyudha's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 7
  • Thank you received: 0

aldiyudha replied the 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.
#21762

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0

roshan zha replied the 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.
#21763

Please Log in or Create an account to join the conversation.

  • Posts: 4
  • Thank you received: 0

roshan zha replied the 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.
#21764

Please Log in or Create an account to join the conversation.

Time to create page: 0.147 seconds