Recent

Author Topic: Problem with SQLQuery and memofield type TEXT  (Read 6120 times)

Fedorax

  • Guest
Problem with SQLQuery and memofield type TEXT
« on: August 20, 2005, 08:06:05 pm »
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

  • Guest
RE: Problem with SQLQuery and memofield type TEXT
« Reply #1 on: August 27, 2005, 03:39:54 pm »
What a success! That's sound like newbies not welcome... Ok, bye.

glober

  • Full Member
  • ***
  • Posts: 130
Problem with SQLQuery and memofield type TEXT
« Reply #2 on: August 28, 2005, 05:37:24 am »
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.

 

TinyPortal © 2005-2018