By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,514 Members | 1,143 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,514 IT Pros & Developers. It's quick & easy.

Numeric error..

P: 2
In Table,i assigned one field as 'Numeric'.But when i save the form without data in numeric field it shows error.how can i rectify it ?
Feb 27 '08 #1
Share this Question
Share on Google+
3 Replies


ck9663
Expert 2.5K+
P: 2,878
In Table,i assigned one field as 'Numeric'.But when i save the form without data in numeric field it shows error.how can i rectify it ?
You could be storing an empty string or a space on that column. Try displaying your dynamic query that you build inside your apps, paste in in sql-analyzer and execute it.

-- CK
Feb 27 '08 #2

debasisdas
Expert 5K+
P: 8,127
If you don'.t want to save any data insert NULL to the field and make that field nullable.
Feb 27 '08 #3

ck9663
Expert 2.5K+
P: 2,878
Or define a default value on your table

-- CK
Feb 27 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.