Page 1 of 1
SQLite Concat returns Memo
Posted: Fri 28 Feb 2014 12:13
by 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)
Re: SQLite Concat returns Memo
Posted: Fri 28 Feb 2014 13:55
by 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.
Re: SQLite Concat returns Memo
Posted: Wed 05 Mar 2014 12:32
by 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
Re: SQLite Concat returns Memo
Posted: Wed 05 Mar 2014 12:55
by 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
Re: SQLite Concat returns Memo
Posted: Wed 05 Mar 2014 16:17
by 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?
Re: SQLite Concat returns Memo
Posted: Thu 06 Mar 2014 10:36
by 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