| Author |
 Topic  |
|
|
es4725
Junior Member
205 Posts |
 Posted - 25 April 2002 : 19:57:41
|
I'm using an access DB, and Using TableEditor to edit it online. I have some fields in the DB that need to hold a value of 0 (zero). When I try to enter this value through TE and click "Save" I get an error. It says "Record Saved" at the top, but the error says:
"Invalid use of Null: 'cstr' te_showrecord.asp line 288"
If you view the record after that, the point where a zero is entered is not shown (nor anything afterwards), and you get the same error. I don't understand why I'm getting the errors. The field is a number field. Any help?
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 25 April 2002 : 20:19:48
|
Perhaps there is some other field that can't be null but you're not editing anything in it. Maybe table editor is changing a zero length string to a null when it rewrites.
======
Doug G
====== |
 |
|
|
es4725
Junior Member
205 Posts |
Posted - 26 April 2002 : 10:03:59
|
All fields contain data. All other Number fields are integers greater than 0, or the number "-1". I get no problems with any records that contain both of those, without zeros. However, if I have a record that contains one zero, I get that error. It prints all the other fields into the DB, but it prints nothing into the field where I put the zero. You can see the results of that here:
http://www.ohio.k12.ky.us/ochs/gbasketball/rosters/player.asp?id=3
There are three places that don't have a value. 3pts made, 3pt percentage, and blocked shots. I had a zero in 3 pts. made, and it's percentage is figured from that field and the attempted field. I also had a zero in the blocked shots field. Does that clear anything up?
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 26 April 2002 : 12:21:46
|
I have never had a problem like this with table editor. Maybe your table editor code pages got corrupted? You could try reinstalling te, or install a 2nd copy of it and see if you get the same problem.
There is a piece of data that table editor expected to be present but it's not, and when the value is being converted to a string it gives you the error message.
======
Doug G
====== |
|
|
|
es4725
Junior Member
205 Posts |
Posted - 26 April 2002 : 17:01:45
|
ok, I'll play with it... thanks.
|
|
|
| |
Topic |
|
Topic Locked
