Could also be default field values or functions
within a default field value. If you open the
debugger and set a watch of PROGRAM()
AND LINENO(), what do you get?
-myron kirby-
===============================
>>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
>
>Is it possible you have mismatched types in a tag... or, you have an alias in a tag that is pointing to the wrong alias...
>
>Try to do append blank and see if you get the same error.. if so it may be an index expression problem or, as Mark said, a trigger problem.
>
>BOb