SQL database not receiving data; but no error from form entry

J

jenlovesholdem

Hello. I have a form in FP 2003 which I have connected successfully to a
table on SQL server. I have the data successfully loading to the table.

Here's where my problem is. I have been testing different scenarios to try
to make an error happen (IE: renaming the table on SQL, updating the format
on the SQL table to not accept nulls, etc). I then go to my form online,
enter some data and still get the basic successful page back, even though
when I go to look at the table, the data isn't there.

Before we put this out there for employees to use, we want to ensure when
there is an error, it shows them an error rather than appearing successful
when it wasn't. I have checked and researched several things, but haven't
found any good answers.

Any help is greatly appreciated.
Jennifer
 
Top