DOUBLE Data type

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
fmichael
Posts: 13
Joined: 2018-04-30 10:30

DOUBLE Data type

Post by fmichael » 2018-08-21 02:38

I have a field in my DB that is set as DOUBLE for data type (Field format set to currency). I upload the code to my server, and when I try to input a dollar amount, I'm only allowed to input the first number and not the rest? So, if I need to input 250.00, I'm only allowed to input the 2 and that's all she wrote. Willing to listen to all or any suggestions that you might have. Thanks.

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: DOUBLE Data type

Post by pbottcher » 2018-08-21 07:06

Hi, can you share the exact definitions you have in AppGini for this field. Also for the DB?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

fmichael
Posts: 13
Joined: 2018-04-30 10:30

Re: DOUBLE Data type

Post by fmichael » 2018-08-22 03:06

OK, here is a link to a picture of the APPGINI:

http://www.ccmagic.us/appgini/appgini1.png

Here is a link to a picture of the SQL database field:

http://www.ccmagic.us/appgini/appgini2.png

Let me know if you need anything else....thanks.

pbottcher
AppGini Super Hero
AppGini Super Hero
Posts: 1635
Joined: 2018-04-01 10:12

Re: DOUBLE Data type

Post by pbottcher » 2018-08-23 10:43

Hi,
can you set the presision to 2?
Any help offered comes with the best of intentions. Use it at your own risk. In any case, please make a backup of your existing environment before applying any changes.

fmichael
Posts: 13
Joined: 2018-04-30 10:30

Re: DOUBLE Data type

Post by fmichael » 2018-08-24 02:51

Well, I think I tried that, but I will try it again and let you know the results. Thanks.

fmichael
Posts: 13
Joined: 2018-04-30 10:30

Re: DOUBLE Data type

Post by fmichael » 2018-08-24 02:56

Well, I must of done it right this time...because now its working. Thanks.

Post Reply