NaN error

N

NikV

I am reading data from an XML file that was generated from a MS database. I
am populating that data into a text field. There could be data and sometimes
there could be no data.

When there is no data, the text box shows a NaN with a red dash line around
the text box. This is preventing the form from saving the data back to the
DB. Is there a way around this so that I can save the data back to the DB
even though there is no data?

Thanks for your help!
 
F

Franck Dauché

Hi,

What data type is the field that gives you trouble in your schema in IP?

Franck Dauché
 
N

NikV

The DataType that is in IP is simpleType, formatted to be currency. The data
Type that I stored in the DB is numeric. Does that answer your question?
 
F

Franck Dauché

Hi,

Can you default your textbox to 0? It should get rid of the issue.

Regards,

Franck Dauché
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Program buttons to create a word document 0
Max(.)+1 results in NaN 2
My formula results in "NaN". What does that mean? 2
Copy previous record into form field 0
Cannot wrap text around an image 1
How do I set focus (and select text) on a text box on a modeless userform? 0
A Look Into The Good and Bad Points of XML 0
Visio 2010 - Deleted shape data fields not disappearing 1

Top