Numeric error..

[lijish]

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 ?

[ck9663]

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

[debasisdas]

If you don'.t want to save any data insert NULL to the field and make that field nullable.

[ck9663]

Or define a default value on your table

-- CK