Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / insert in table
Microsoft Dynamics GP (Archived)

insert in table

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I created a form in Dexterity where I added the field percentage. When I click on the save button the value is inserted in my database table through an sql query. However I have used some formatting to get rid of the % sign and save the number. It looks like this:

 PRCNTAGE='" + (format('Percentage' of window 'Window1' of form 'Form1' ,false, false, 5, MINUSNEG))  + "'

The above works on my computer but when i installed on the client it fails to read the percentage form the form and instead inserts 0.00 in the table. I am guessing that something is wrong with the formatting.

Please advice. Thanks in advance

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    Re: Re: insert in table

    nevermind,

    i got it to work i replaced the comma it was reading from the percentage input on the form with a decimal point

     thanks

  • winthropdc Profile Picture
    winthropdc on at
    Re: insert in table

    Normally all the formatting is handled using a format such as INT5_%2.

    The actual number is stored without the format.  You should not need to format it to store the number.

    Maybe, the code will make this easier to understand.

    Thanks

    David

    David Musgrave [MSFT]
    Escalation Engineer - Microsoft Dynamics GP
    Microsoft Dynamics Support - Asia Pacific

    Microsoft Dynamics (formerly Microsoft Business Solutions)
    http://www.microsoft.com/Dynamics

    mailto:David.Musgrave@online.microsoft.com
    http://blogs.msdn.com/DevelopingForDynamicsGP

    Any views contained within are my personal views and not necessarily Microsoft policy.
    This posting is provided "AS IS" with no warranties, and confers no rights. 

     

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans