ronchan Posted September 28, 2008 Share Posted September 28, 2008 I have a column called 'jobnum' (varchar, 10) but when I created a new file the default value always ends up to be '1245'. If I try to change the value it still ends up to be '1245'. If I import into the column I can enter any number I want. What does '1245' mean and what am I doing wrong? Thanks! Quote Link to comment Share on other sites More sharing options...
CroNiX Posted September 28, 2008 Share Posted September 28, 2008 Maybe you have a default value set in the db? Quote Link to comment Share on other sites More sharing options...
ronchan Posted September 28, 2008 Author Share Posted September 28, 2008 Nope. No default. Quote Link to comment Share on other sites More sharing options...
PFMaBiSmAd Posted September 28, 2008 Share Posted September 28, 2008 You are not providing any useful information for anyone to help you. Obviously either the data entered in a form, your code, or the table definition is causing this as computers only do what they are told. You would need to post your form, your form processing code, and your table definition for anyone to be able to help you with what your code or your table is doing. Quote Link to comment Share on other sites More sharing options...
ronchan Posted September 28, 2008 Author Share Posted September 28, 2008 Looked over my coding and everything seemed correct. I thought that '1245' might have been some sort of error code. Apparently not - so I'll check the code a few more times. Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.