Need help with access to a FoxPro data file that has an index using a user-defined function.
Error is:
Error: Index \\10.0.0.21\jlctest\MogDev\livedata\todonote.cdx should have an invalid index expression phd('MTNNOTES',LEN(tnnotes),'MTNMISC',LEN(tnmisc)), since failed to find column phd('MTNNOTES',LEN(tnnotes),'MTNMISC',LEN(tnmisc)) !
SQLState: S0022
ErrorCode: 213249
Found similar issue on another support ticket:
http://www.hxtt.com/support_view_issue.jsp?product=dbf&id=1327436208
That was 2 years ago. I see that version 5.2 is now released. Does it handle user-defined functions on indexes?
|
Extend SQL functions is at here.
|