News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) [Dexterity] How to add...

Microsoft Dynamics GP (Archived)

[Dexterity] How to add more keys for SOP10104?

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Community Member Microsoft Employee on at

Like (0)

Report

RE: [Dexterity] How to add more keys for SOP10104?

Hi Anvar:

Thank you so much for your help.

My problem has been solved!

Billy
Verified answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: [Dexterity] How to add more keys for SOP10104?

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

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,391 Super User 2024 Season 2

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans