7.0.6 SQLite Query return erroneous blob field type

[lfcap]

7.0.6 and SQLite 3: Query with multiple tables return erroneous blob field type

For example, in my database I create 2 tables:
T1 as 2 or more fields (F1 INTEGER, F2 BLOB, …)
T2 as 2 or more fields (Fa INTEGER, Fb VARCHAR, …)

With TZReadOnlyQuery or TZQuery if I set SQL text as
“Select F1, F2 From T1”
then the dynamic created field type for F2 is ftBlob that work.

Now, if I set SQL text as
“Select T2.Fa, T1.F2 From T2 left join T1 on (T1.fx=T2.fx) »
then the dynamic created field type for F2 is ftString : incorrect type.

Thanks for your help

[EgonHugeist]

http://sourceforge.net/p/zeoslib/tickets/51/