SQLite Concat returns Memo

[Andidreas]

Hi,

since I've updated my UniDac Version to 5.2.7 I have the Problem that Fields which i concatenate in the SQL Statement would be shown as Memo...

Pls check! I don't understand why!

I use for example the following SQL Statment:

Code: Select all

Select Field1 || Field2 || Field3 From TestTable

Result in the DBGrid is --> (Memo)

[AlexP]

Hello,

When using concatenation, SQLite returns the Unknown data type, therefore we map fields of this type to ftMemo. You can use the DataTypeMappingtechnology to map the field type to a required type.

[Andidreas]

your new version of the unidac component is quite a joke!!!
and therfore we have to pay???

why, please explain why return your component a ftMemo Data Type when i say in my sql statement

select field1, "0" as TestColumn from testtable

[AlexP]

As I wrote you earlier, SQLite returns Unknown type for the TestColumn field, and since we don't know the type of the data stored in this column, we map it as ftMemo

[Andidreas]

Yepp, you wrote that.
But this was your answer for my problem with the concatenate of Fields in a SQLite SQL Statement.

What i know did was that I create a Column with Blanks as Field Content, and in this case i also get the ftMemo Datatype which is quite not logical for me!

Code: Select all

Select Field1, Field2, "" as EmptyColumn From Test_Table

And why does this work w/o any issues in the previous versions?

[AlexP]

For such cases, we have implemented the DataTypeMapping technology, that allows to specify the Delphi type for such fields in a query: http://www.devart.com/litedac/docs/data ... apping.htm