Board index » delphi » dbExpress & MySQL & superb DbGrid

dbExpress & MySQL & superb DbGrid


2003-11-29 06:26:38 AM
delphi134
Hi,
I'm looking for an extended TDbGrid component, capaple of communicating with a
MySQL database through the dbExpress. The features I am interested in are:
- an external multi-line editing window for MEMO fields
- an external window for editing fields of SET or ENUM types
(checkboxes/radiobuttons for every possible values)
I'd like this windows to open after clicking a small "elipsis" button in the
right corner... Anyone saw such a component?
If not, could you give me suggestions how could I write such a component by
myself? (basing on the standard TDbGrid or any other grid)?
Pawel
 
 

Re:dbExpress & MySQL & superb DbGrid

I never found any "free" ones that I'd place in the superb category, but there are many.
You would get better (and quicker) answers if you asked in b.p.d.thirdpartytools group.
Or search google. Many vendors will let you "try" their grid for free (eg. for some trial
period, or as long as IDE is detected as running)
delphi provides native support for 'hooking' an ellipsis in grid cells, so it would not be
colossally difficult to write your own.
-paladin
"Pawel" <XXXX@XXXXX.COM>writes news:XXXX@XXXXX.COM...
Quote
Hi,

I'm looking for an extended TDbGrid component, capaple of communicating with a
MySQL database through the dbExpress. The features I am interested in are:

- an external multi-line editing window for MEMO fields
- an external window for editing fields of SET or ENUM types
(checkboxes/radiobuttons for every possible values)

I'd like this windows to open after clicking a small "elipsis" button in the
right corner... Anyone saw such a component?

If not, could you give me suggestions how could I write such a component by
myself? (basing on the standard TDbGrid or any other grid)?

Pawel

 

Re:dbExpress & MySQL & superb DbGrid

"paladin" <XXXX@XXXXX.COM>:
Quote
delphi provides native support for 'hooking' an ellipsis in grid cells, so
it would not be
colossally difficult to write your own.
The main problem is: how can I get all the possible values of the ENUM field
in a MySQL database (I'm using the dbExpress connector and a MySQL driver)? Is
it possible to do it using only the TDataSet or TClientDataSet?
pg
 

Re:dbExpress & MySQL & superb DbGrid

Hello, Pawel!
Quote
The main problem is: how can I get all the possible values of the ENUM
field in a MySQL database (I'm using the dbExpress connector and a MySQL
driver)? Is it possible to do it using only the TDataSet or
TClientDataSet?
When you first show the grid you will need to set up a temporary TSQLQuery
that does a "DESCRIBE <tablename><fieldname>" and then parse the field
values from it.
Cheers,
Ignacio
--
Henshin-a-go-go, baby!
 

Re:dbExpress & MySQL & superb DbGrid

hi pawel.
it is not free but check out the demo of the ExpressQuantumGrid Suite
from www.devexpress.com .
volkmar
acs data systems
"Pawel" <XXXX@XXXXX.COM>writes news:<XXXX@XXXXX.COM>...
Quote
Hi,

I'm looking for an extended TDbGrid component, capaple of communicating with a
MySQL database through the dbExpress. The features I am interested in are:

- an external multi-line editing window for MEMO fields
- an external window for editing fields of SET or ENUM types
(checkboxes/radiobuttons for every possible values)

I'd like this windows to open after clicking a small "elipsis" button in the
right corner... Anyone saw such a component?

If not, could you give me suggestions how could I write such a component by
myself? (basing on the standard TDbGrid or any other grid)?

Pawel
 

Re:dbExpress & MySQL & superb DbGrid

be advised that this did not work for all versions of mysql. See the
qc reports #1810 and #4160 for example .
but for the latest versions of mysql and dbexpress driver, all is
supposed to be fixed and working.
-paladin
"Ignacio Vazquez" <ivazquezATorioncommunications.com>writes news:XXXX@XXXXX.COM...
Quote
Hello, Pawel!
>The main problem is: how can I get all the possible values of the ENUM
>field in a MySQL database (I'm using the dbExpress connector and a MySQL
>driver)? Is it possible to do it using only the TDataSet or
>TClientDataSet?

When you first show the grid you will need to set up a temporary TSQLQuery
that does a "DESCRIBE <tablename><fieldname>" and then parse the field
values from it.

Cheers,
Ignacio

--
Henshin-a-go-go, baby!