Re: [mdb-dev] mdb-sql problem

[Dmitry V. <dm...@rs...>]

--- Dmitry Vereschaka <dm...@rs...> wrote:

DV> There is a problem with mdb-sql and my mdb file - mdb-sql refers to wrong column while
DV> executing sql "select PP_Info from PlatPor where PP_Info like '%q%'".
DV> If you look to output below or if you open this mdb file with ms access, you will find
DV> that mdb-sql
DV> actually compares 'Rec_INN' field, not 'PP_Info' with '%q%'.
DV>
DV> It is very strange, because mdb-export produces correct column name bindings with this
DV> file (output
DV> also shown below)
DV>
DV> If someone interested in solving this problem, please contact me via email and I'll
DV> send you this
DV> broken mdb file (400K zipped).

I've resolved this problem (see patch1 attached).

Also I've added support for datetime type in SQL's WHERE (see patch2 attached), unfortunately, it is
really slow (every row's datetime field is converted to string and comparing with search parameter
as string instead of converting search parameter to double once and comparing it with row's datetime
field as double. So, the search parameter should be in 'YYYY-MM-DD HH:MM:SS' format.

-- 
 Dmitry                          mailto:dm...@rs...