problem with user input

Ask the community
,
1

1.I created a user input for a number and set the input to be a number, I connented it to the database to a collumn that is also set to be a number and still when I insert a number the database view it as a text.
2. I displayed the top 3 numbers from the database to the page but when I insert a number to the user input it shows in the top three before i even submit.

2

Hi,

  1. This seems to be an issue. We will look into this.

  2. If you are editing one of the existing numbers, changes to it do reflect in other components bound to the same dataset (assuming you submit data through Dataset). If you are adding a new one, these do not normally show up. If you care to share your site, I could look it up to see what may be the issue.

3

Hi,

This is the link to the site https://orchuk100.wixsite.com/hireor

Thanks for any help

4

I see. You are using Write-Only Dataset to both display and insert the data. What I would suggest in this case, to use two different Datasets, one for inserting and another for displaying top 3 results.

If you need the top 3 view to refresh after submit, you could do it from code by refreshing Read Dataset in Write Dataset’s onAfterSubmit event handler.

I hope this helps. Please let me know if you need any further assistance.

5

Thank you it helped a lot!
There is still the problem with the input of the numbers …