>> > > Error building key for index "c:\abc\shipment.cdx" tag >> "Locitemdat." >> > > >> > >The SHIPMENT table has an index tag called LOCITEMDAT that is made up of >> > >LOCATION+ITEM+DTOC(SHIPDATE). LOCATION is c(2) and ITEM is c(20). ... >> > [EMAIL PROTECTED] On Behalf Of Charlie Coleman >> > Sent: Thursday, August 21, 2008 11:48 AM ... >> > Also make sure that the strings in the MEMVAR do not evaluate to greater >> > than 240 characters. ... At 11:19 AM 8/21/2008 -0400, John J. Mihaljevic wrote: >And the MEMVAR stuff would only matter with the INSERT INTO approach anyway, >correct? That shouldn't matter when I'm getting the same error with APPEND >BLANK.
Sorry. I don't think I read your original post close enough. I wasn't sure how you got the data assigned to the MEMVAR. E.g. if you did a SCATTER ..... MEMVAR, then you assigned data to the MEMVAR variables, one or more of the strings may have been larger than allowed by your index. But later you said you got the error on an "APPEND BLANK" statement so what I was thinking wouldn't apply there. The only thing I'm wondering about is if VFP 9 handles the data types differently than they were handled in VFP 6. I think someone else already mentioned the DTOC() has other parameters that may need to be filled in (maybe VFP 9 defaults to a different result than VFP 6 does). And maybe try to alter the structure of the table using VFP 9 and specify the index there (on a copy of the DB of course). See if the index can be created interactively in VFP 9. -Charlie _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
