web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / [Solved]range ...
Microsoft Dynamics GP (Archived)

[Solved]range table tablename where upper(physicalname)

(0) ShareShare
ReportReport
Posted on by Sridhar Narayanan 1,027

Hi,

I am facing a strange scenario in setting range on the records.

I am not able to set the range or some table to fill in the scrollinw window. Following is the statement I am using to set range.

range table is_Doctor_Master where upper(physicalname(is_Doctor_Name of table is_Doctor_Master))+ " LIKE '%"+ upper((L) Search_String) + "%'"; 

Similar kind of range statement is working fine for some other table, but I am not able to figure how the statement is not working for the above mentioned table.

More Info

1. The above statement is worign fine in my local environment where the sql collation is SQL_Latin1_General_CP1_CI_AS but in the stage environment the collation is Arabic Binary.

Please guide me to resolve this issue.

Thanks,

Sri

 

 

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    Hi Sri,

    Have you considered using Dexterity to create and fill the scrolling window?

    Kind regards,

    Leslie

  • Sridhar Narayanan Profile Picture
    Sridhar Narayanan 1,027 on at

    Yes, after setting range I am filling the scrolling window.

    My requirement is to list all doctor info which contains the search string. That is why I am usign LIKE in range statemet.

    When I debug the code, it seems that sometimes system is not recognizing upper(physicalname ........).

    I want to simulate Dex query simillar to select  * from Doc10000 where upper(docname) like upper('%xxx%')

    Thanks,

    Sri.

  • Sridhar Narayanan Profile Picture
    Sridhar Narayanan 1,027 on at

    Hi,

    The issue is resolved.

    Instead of using range table tablename where upper(physicalname(field name))....we have to use

    range table tablname where "upper(technical field name).....

    For eg:-  select  * from Doc10000 where upper(docname) like upper('%xxx%') can be simulated in Dex as

    range table Doc10000 where "upper(DocName) like " '%" + upper(Search_String) + "%'";

    Thanks,

    Sri.

     

  • MG-16101311-0 Profile Picture
    MG-16101311-0 26,225 on at

    I am not sure if this will work, but try this:

     

    range table is_Doctor_Master where upper(physicalname(is_Doctor_Name of table is_Doctor_Master)) + " LIKE '%" + upper('(L) Search_String') + "%' COLLATE ARABIC_BIN;";

    Note the addition of the COLLATE clause to the range criteria. However, if your doctors' names are stored in Arabic then I am afraid none of this will work. Take a look at my article Microsoft Dynamics GP and SQL Server Collations for more information.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans