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) / [Dexterity] How to add...
Microsoft Dynamics GP (Archived)

[Dexterity] How to add more keys for SOP10104?

(0) ShareShare
ReportReport
Posted on by Community Member

Hi Experts!

I'd like to add a new key for table SOP10104 in dexterity.

The Key Segments contains only one Fields: SOP Number and need create Index.

Then I went to Microsoft Dynamics GP => Maintenance => SQL 

Selected Database and Product.

Found the table "Sales Tracking Number Work History" and check all the check box on the right.

The Index didn't created into my table in the Database and it could be used in the code or a run time error would be throw by GP.

The data has been cleared so I'm sure the table I selected is correct.

Could you please help to figure out how to add more keys for SOP10104?

I'm using GP 2015 and Dexterity 14.0.

Thanks

Billy

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member on at

    You can assign the key through Dexterity coding.

    Syntax:

    assign key_variable as key for table table_name {with key_options} using table_field {with segment_options} {, table_field {with segment_options}}...

    Function Name: assign as key

    Please follow the Sanscript manual for more information

    https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=1&ved=0ahUKEwihvPX5n8zUAhUMLI8KHZEgB2kQFggnMAA&url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2F9%2Fb%2F8%2F9b82dd0a-cecb-4946-8eea-0e2917bf0351%2Fdexterity%2FSANSCRPT.pdf&usg=AFQjCNEOrat5PwYT5K7-8sugmcTwq6qlVw&sig2=lB7VPRgw6_nHd5Zww1uZLw

    Thanks,

    Anvar

  • Community Member Profile Picture
    Community Member on at

    Hi Anvar:

    Thank you so much for your help.

    My problem has been solved!

    Billy

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