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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

How to add/ remove a Column to an existing Temp table on the fly in Dexterity.

(0) ShareShare
ReportReport
Posted on by 235

Hi,

I have a scenario were I am planning to add a new columns to the existing temp table. Can any one let me know is it possible in Dexterity.

 

Thanks & Regards

Virupaksh Ghatage

 

*This post is locked for comments

I have the same question (0)
  • Dave Dusek Profile Picture
    on at

    Unless the existing temp table is your own custom table, then you would not be able to alter the table definition.  You can only change your own tables in your own dictionary.  

  • Virupaksh Ghatage Profile Picture
    235 on at

    Thanks Dave,  actually I am trying to use the result of  dynamic sql select statement , so is there any ways to use the result in the form of table in dexterity.

  • Verified answer
    Dave Dusek Profile Picture
    on at

    The only way is if the table is defined in dexterity.  You can define your own temp table, you can populate that with SQL, but the columns can't change.  You would have to set the columns up and then use them that way.  

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans