hi: i have a fox 2.6 database with cdx indexes as show bellow:
key: dtoc(us_birth,1)+us_name+us_prof
so in fox i can do this query "select * from database where dtoc(us_birth,1)+us_name+us_prof='2012'", but using HXTT DBF V. 3 doesn't work, what i'm doing wrong.
Please could you help me
|
>select * from database where dtoc(us_birth,1)+us_name+us_prof='2012'
select * from database where dtoc(us_birth,1)+us_name+us_prof like '2012%'
Then HXTT DBF will utilize index to get your result.
Foxpro's syntax is not standard SQL syntax. = means == in SQL.
|
hi: i was trying also with 3.0v but does not support '%', how can i solve this problem
|
Do V3.0 means HXTT DBF JDBC 3.0 packge v5.1? In my test, it supports your sql sample.
|