Recent

Author Topic: [SOLVED] TDBMemo basic usage not works in runtime (MySQL)  (Read 1991 times)

tsr

  • New Member
  • *
  • Posts: 21
[SOLVED] TDBMemo basic usage not works in runtime (MySQL)
« on: January 27, 2016, 12:24:03 am »
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?
« Last Edit: January 28, 2016, 10:34:41 pm by tsr »
Ubuntu 64bit

Jurassic Pork

  • Hero Member
  • *****
  • Posts: 1228
Re: TDBMemo basic usage not works in runtime (MySQL)
« Reply #1 on: January 27, 2016, 01:56:17 am »
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
Jurassic computer : Sinclair ZX81 - Zilog Z80A à 3,25 MHz - RAM 1 Ko - ROM 8 Ko

tsr

  • New Member
  • *
  • Posts: 21
Re: TDBMemo basic usage not works in runtime (MySQL)
« Reply #2 on: January 27, 2016, 07:33:12 pm »
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?
Ubuntu 64bit

Jurassic Pork

  • Hero Member
  • *****
  • Posts: 1228
Re: TDBMemo basic usage not works in runtime (MySQL)
« Reply #3 on: January 28, 2016, 05:02:17 am »
hello,
can you put your zipped project (lpi,lpr,pas,lfm files) in attachments to see what is wrong.

Friendly, J.P
Jurassic computer : Sinclair ZX81 - Zilog Z80A à 3,25 MHz - RAM 1 Ko - ROM 8 Ko

tsr

  • New Member
  • *
  • Posts: 21
[SOLVED] TDBMemo basic usage not works in runtime (MySQL)
« Reply #4 on: January 28, 2016, 10:34:24 pm »
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!
Ubuntu 64bit

 

TinyPortal © 2005-2018