Problem with SQLQuery and memofield type TEXT
lazarus / 16-Databases

----------------------------------------------------------------------
Fedorax · 2005-08-20 18:06

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.

----------------------------------------------------------------------
Anonymous · 2005-08-27 13:39

What a success! That's sound like newbies not welcome... Ok, bye.

----------------------------------------------------------------------
glober · 2005-08-28 03:37

It's not a question of being welcome or not, I personally don't have
an answer for you. My suggestion would be to try asking the question
on the mailing list. You will probably have better success there.