Detecting MEDIUMTEXT vs. VARCHAR in a DBGrid
I'm using Delphi 7, MySQL 5.0, MyODBC connector 3.51 with an ADODataSet component from the ADOnis component suite by Winsoft.
In my program's DBGrid, I want VARCHAR fields to be displayed and edited on the grid, but MEDIUMTEXT fields to be edited in a popup edit window. When connecting to a MS Access or MS SQL database, this was no problem: I could look at TField.DataType and if it was ftMemo, then I knew it was a memo field (the equivalent of MySQL's MEDIUMTEXT) and override the default DBGrid editor with my own popup window. But when connecting to a MySQL database, TField.DataType shows both VARCHAR and MEDIUMTEXT as ftString, so I can't tell the difference. Anyone know how I can distinquish?
Subject
Written By
Posted
Detecting MEDIUMTEXT vs. VARCHAR in a DBGrid
November 29, 2006 10:14AM
December 07, 2006 04:15AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.