[SOLVED] TDBMemo basic usage not works in runtime (MySQL)
lazarus / 16-Databases

----------------------------------------------------------------------
tsr · 2016-01-26 23:24

Hi,

I've created very basic form with TDBGrid and TDBMemo on it. I have
connection to database and working the DBGrid.

TDBMemo.DataField is setted to proper name of my MySQL field (datatype
of this field is TEXT).

It doesn't display anything in "Runtime" but displaying content on
"Designtime" (if connection is active).

What could be wrong?

----------------------------------------------------------------------
Jurassic Pork · 2016-01-27 00:56

Hello,
what are the database components used (data control,data access , zeos
or sqldb) ? What is the type of database  (mySQL ?) ?
Are you doing something on FormCreate event ?

Friendly J.P

----------------------------------------------------------------------
tsr · 2016-01-27 18:33

I use standard components: TSQLQuery, TDataSource, TSQLTransaction and
TMySQL55Connection. MySQL client version is 5.5.

This is very basic example program.
SQL: SELECT * from `table`
TSQLQuery.Open

thats all

It affects also other "one field" DB components. Any of theese not
display anything on runtime.

Maybe I'm not doing something important?

----------------------------------------------------------------------
Jurassic Pork · 2016-01-28 04:02

hello,
can you put your zipped project (lpi,lpr,pas,lfm files) in attachments
to see what is wrong.

Friendly, J.P

----------------------------------------------------------------------
tsr · 2016-01-28 21:34

Sorry for confusion. I think that I isolate basic example but if I
make new application project from scratch it works like it should.

The problem is in TFrame approach. If you make one frame with DBGrid
and DataSource, and then use that frame on some other frame and add
DBMemo then strange things occurs. Do not place TDataSource alone in
TFrame.

Thank you for your willingness to help!