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

  • Mariano Gomez Profile Picture
    Mariano Gomez 26,225 on at
    Re: [Solved]range table tablename where upper(physicalname)

    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.

  • Sridhar Narayanan Profile Picture
    Sridhar Narayanan 1,027 on at
    Re: Re: Re: range table tablename where upper(physicalname)

    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.

     

  • Sridhar Narayanan Profile Picture
    Sridhar Narayanan 1,027 on at
    Re: Re: range table tablename where upper(physicalname)

    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.

  • L Vail Profile Picture
    L Vail 65,271 on at
    Re: range table tablename where upper(physicalname)

    Hi Sri,

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

    Kind regards,

    Leslie

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,202 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans