HXTT DBF
Like search with escape
Rob Gansevles
2014-01-14 00:45:37.0
Hi,

I have downloaded the latest DBF_JDBC40.jar on which one of our automated tests fail.
The following sql works fine with an older version:

create table tst (x varchar(10))
insert into tst (x) values ('a_b')
insert into tst (x) values ('axb')
select * from tst where x like 'a\__' {escape '\'}

Error: Syntax error: Stopped parse at {(id18)
SQLState: 2A000
ErrorCode: 172032

Expected result is the first record returned

Regards,
Rob
Re:Like search with escape
HXTT Support
2014-01-14 07:31:17.0
Supported. Please download it.
Re:Re:Like search with escape
Rob Gansevles
2014-01-16 00:42:52.0
It works, thanks for the quick response.
Rob


Google