Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid key length
Message
From
12/09/2006 10:13:29
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01153006
Message ID:
01153019
Views:
20
>>>Hi everybody,
>>>
>>>We're having some strange errors. I've checked the error log and found that biz object post save hook method failed with Invalid Key Length message. I've checked help on this error, but it's still not clear to me what may have cause this problem. AFAIK all our indexes are created with machine collating sequence.
>>>
>>>Do you have experience with this problem and can you give some advices?
>>>
>>>Thanks in advance.
>>
>>Even machine collating sequence have an index key length, namely 240.
>>Cetin
>
>I wish this error gave me a table name at least. I quickly looked into the code (my colleague's) and I see a lot of going on in PostSaveHook of the biz object save. The new records are added, the select statements are executed, the save of other biz objects called. I guess he needs a much better way to track the possible errors than we have now.

Select statements might be the cause. With SQL it's possible to create that error w/o having an index (rushmore optimization trying to create index behind the scenes).
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform