>I have a weird line of code that I can't get to behave, normally a very simple process:
>
>INSERT INTO EntHead ( PKey, CustFKey, EntryNo ) VALUES ( nPKey, Customer.PKey, cEntryNo )
>
>Whenever that line is invoked, I get an Error #9--Data Type Mismatch. However, the data types do not mismatch (they are N (Int), N (Int) and C respectively). When I clear the error message, the record is properly appended and all three fields are properly filled in. I have tried eliminating the fields one at a time. If I, for example, only put PKey and nPKey in the INSERT INTO line, I get a Mismatch error. nPKey is the last used PKey + 1--definitely not a mismatch. I have moved the line around and even re-typed it. Same thing--the error follows this line. Everything works fine after I clear the error message, but I can't give the program to my client like this.
>
>Anybody seen anything like this?
>
>TIA.
>
>John
See if you don't have an insert trigger in this table.
Mark McCasland
Midlothian, TX USA