Hello,
I've problem with componet SQLDBLaz. I can't read a memo field if his type is TEXT.
If i do something like:
--------------
SQLQuery_01.SQL.Text:='SELECT * FROM '+Table_Name;
Datasource_01.DataSet := SQLQuery_01;
SQLQuery_01.Open;
-----------
My memo field have no colum in DBGrid, If i link with a field DB memo i've error message: Field not found "DESCR"
Same thing happen if i use the fieldbymane fonction. This happen only with TEXT type, no problem with BLOB or binary. What can i do to read my text fields ?
My OS: Linux fedora 4
MySql Version: 4-1-12-2.fc4.1
Lazarus version:0.9.9 beta 20050813
Thank's for help.
----------
Note: I Cant'read but with:
---
SQLQuery_01.SQL.Text:=' CREATE TABLE 0test (CODE VARCHAR( 12 ),DESCR TEXT NOT NULL)';
SQLQuery_01.SQL.Text:='INSERT INTO `0test` ( 'CODE' , `DESCR` )VALUES ("0001245", "test champ memo text")';
SQLQuery_01.ExecSQL;
------
I can create and write memo text field.