Devart Forums

Hi,

How can I achieve this.
Is there any mydac method making this posible (retreive a list) so that i can automatically fill my DBCombobox with ?

Thank

There are no easy ways but you can analyse query result SHOW CREATE TABLE

Hi Ikar, competitors product has this feature, and when you attach a grid to their query it show already the ENUM values. This would be a very nice feature for myDac.

Regards

Doesn't MySQL provides C api for this ?

> Hi Ikar, competitors product has this feature, and when you attach a grid to
> their query it show already the ENUM values.

Please specify what product you mean.

> Doesn't MySQL provides C api for this ?

Not, MySQL API and MySQL Protocol don't provide this information. To obtain it you need to execute an additional query and then analyze it.

Also VCL doesn't provide a way to pass this information from TDataSet descendants to TControl descendants.

Hi Ikar, it's Micro0lap's that provide this functionality. Last year when i evaluated both products i noticed that theirs provide this functionality, but CRLab's Mydac is better support & speed.

Right now I solved this problem using DevEx cxDBImageLookup's and setting internally the different values. But it has one disadvantge, when you change DB you have to add/remove values from program.

If you want to determine all possible values for an ENUM column, use SHOW COLUMNS FROM tbl_name LIKE enum_col and parse the ENUM definition in the second column of the output.
(c) MySQL AB

We will consider a possibility of adding this feature in MyDAC 3.10.

3.10 or 4.10 ?

Misprint
Must be 4.10

Hello,


I am curious as to if this feature was implemented? And if so how would you use it?

We have investigated the problem deeply.
Unfortunately ENUM and SET fields are very poorly supported in MySQL protocol. Moreover, TField and data-aware visual components do not provide functionality necessary to handle these fields. So implementing enhanced support for ENUMs and SETs is rather problematic. We recommend to use dictionary tables in cases where ENUM or SET fields might look suitable.