× 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...

JSH SELECT where the select criteria value is interpreted as MATCHES format

Start
Prev
1
Next
End

MasterL
Topic Author
Offline
Premium Member

7 years 4 months ago #20674 by MasterL

JSH SELECT where the select criteria value is interpreted as MATCHES format was created by MasterL

Hi guys,

Who has encountered a similar scenario where the SELECT fails to produce results because it interprets the values given after the operand as a MATCHES format?

For instance, you can provide

jsh ~ -->SELECT FBNK.AA.ARR.PROXY.PERMISSIONS WITH @ID LIKE "AA132174C5NT..."

No Records selected

jsh ~ -->

T24 interprets the *5N* in the ID as a format and then searches for records with IDs matching that criteria - 5N which means a record with ID having 5 digits (jbase.com/r5/knowledgebase/manuals/3.0/3...man/jbc2_MATCHES.htm)

How do I turn this off? This is affecting greatly the accuracy of data being extracted

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

7 years 4 months ago #20675 by VK

Replied by VK on topic JSH SELECT where the select criteria value is interpreted as MATCHES format

Hi
enclose literal string to single quotes:

SELECT FBNK.AA.ARR.PROXY.PERMISSIONS WITH @ID LIKE "'AA132174C5NT'..."

Cheers
VK

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

MasterL
Topic Author
Offline
Premium Member

7 years 4 months ago #20682 by MasterL

Replied by MasterL on topic JSH SELECT where the select criteria value is interpreted as MATCHES format

Thanks VK.

Worked beautifully.

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

Start
Prev
1
Next
End

Time to create page: 0.130 seconds