在HXTT DBF driver中我们发现STR(123) = STR (123,10)
这个默认长度10和Clipper不太一样，直接导致使用HXTT DBFDriver无法从Clipper创建的索引
（例如STR(number)）获取正确结果
有什么方式可以修改这个默认长度或者替换drive自带的STR函数
|
In dbase/Foxpro
If nLength is omitted, nLength defaults to 10 characters.
In Clipper:
Results of STR() with No Optional Arguments
------------------------------------------------------------------------
Expression Return Value Length
------------------------------------------------------------------------
Field Variable Field length plus decimals
Expressions/constants Minimum of 10 digits plus decimals
VAL() Minimum of 3 digits
MONTH()/DAY() 3 digits
YEAR() 5 digits
RECNO() 7 digits
So the best solution is using
STR(nNumber, nLength) as index expression.
|
Main
webmaster@hxtt.com