You’re offline. This is a read only version of the page.
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
Hi Anvar:
Thank you so much for your help.
My problem has been solved!
Billy
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
Thanks,
Anvar
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,134
Super User 2024 Season 2
#2
Martin Dráb
229,928
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (