Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
danniel.din
Starting Member
2 Posts |
 Posted - 2014-08-05 : 20:58:39
|
Good dayI am working as a tech support guy in a postal company. Our new project is upgrading/migrating our postal software/database known as IPS. The new machine and database are all set but I am having problem with a statement to be run in SQL written in the installation manual.I am new to SQL and the software itself built the database. When I did this. I get this error.I am certain that PHA is the correct operator code. I also have the same result when I input CHA which the manual gave as an example.And this is the screenie of the c_config table.What do you think Im missing here? Should there be a Operator code column? What is the statement means?Thanks and regards.dannieldin |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2014-08-05 : 21:49:58
|
| Don't post images. Paste the actual code (and error output) you are trying to run using code tags (see faq)Be One with the OptimizerTG |
 |
|
|
bitsmed
Aged Yak Warrior
545 Posts |
Posted - 2014-08-05 : 22:00:35
|
Most likely the operatorcode is char or varchar field, and if this is correct, operatorcode should be in quotes, something like:insert into c_config values ('Operator code','PHA') |
|
|
|
danniel.din
Starting Member
2 Posts |
Posted - 2014-08-05 : 22:27:49
|
| Thanks bitsmed! it now works fine. thank you!dannieldin |
|
|
|
|
|
|
Problem with statement to be run