Hi all,

I have an application that's returning an error, and I'm not able to figure
out why this particular error is being returned.

The line of code is:

        INSERT INTO shipment FROM MEMVAR

The error I'm getting is:

        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).

I also get the error when I select the table first and try to add the record
another way:

        SELE SHIPMENT
        APPEND BLANK
        GATHER MEMVAR

The APPEND BLANK line gives the same error.

This is something that works perfectly fine when the system is run in VFP6,
but we're trying to bring everything into VFP9.  When running this in VFP9,
the error occurs.

My first thought was to check SET ENGINEBEHAVIOR, but it doesn't appear that
anything in there would affect INSERT INTO or APPEND BLANK.

Any suggestions/solutions would be greatly appreciated.

Thanks very much!

John



_______________________________________________
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.

Reply via email to