Error Building Key for Index
Due to upgrading to vfp9 from vfp8 on Monday, I have had a few small errors that I believe are related to upgrading. Some of the errors have had nothing to due with upgrading but my first instict is to blame the problem on the upgrade.
I'm getting the above error from a program that has been in place since vfp6 and has not had any modifications since then. The error is firing when using tablebuffering and issueing GETNEXTMODIFIED(0). I have never encountered this error but by doing a little research I found that the most common reason for getting this err message is due to the following:
This error is generated when index key truncation is about to occur, typically during index creation or modification such as with the INDEX command. This can happen with use of a key that contains an expression involving a Memo field, whose length in not fixed. <- Taken from msdn.Microsoft
This explanation has been of very little help since the index being used is on 2 fields and neither of them are Memos. The actual index is created by combining a character field with length = 11 and a date field that is converted to character and trimed. ex: char(11) + alltrim(dtoc(datefield)).
I have opened the table from within vfp's command line. Turned on buffering, modified a record, issued getnextmodified(0) and tableupdate() and no error. The error is only ocurring from within the program. I have packed and reindexed the table but still a no go.
If anyone can tell me what I am missing I would appreciate it.
Kendall Dixon
Data Integration Programmer
Tusculum College
Greeneville, TN 37743
423.329.5353