Insert defaults to other field.

[hexOffender]

This should be so simple, but for some reason, this insert statement wont insert in the field I want it to.

insert into SchEncounterForm(ClinicForm)values('Y')

However, when I run the command, it tries to insert into the First column of the table, instead of the ClinicForm column.

 

[gmmastros]

Do you have any triggers on the table?

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[hexOffender]

No there aren't any triggers on this table, but on others there may be. I created this table on an already existing DB.