Unknown data type (28)

[PaulG]

EAssertionFailed 'Unknown data type (28) (D:\Projects\Delphi\Dbx\Source\dbexp.pas, line 1269)'

The problem occurs with a large project with a large table but I have managed to strip it down to the following:

Sqldataset1.SetSchemaInfo(stColumns, 'crash', '');
Sqldataset1.Open;

The exception occurs on the call to SqlDataset1.Open.

The table called crash has one column: problemcolumn DECIMAL(15,6).

Delphi 7
MySQL 5.0.15-nt
dbxexpmda.dll 2.60.0.0

Any ideas?

Paul

[Ikar]

We couldn't reproduce the problem.
Please send us (dbxmda*crlab*com) a complete small sample to demonstrate it and include script to create and fill table.

[dirkdeberlanger]

Hi

I'm having exactly the same issue as described above. No problem to normally open clientdataset for a table with decimal fields in it. But when you try to use the sqlDataSet.SetSchemaInfo(stColums,'tablename','') and open I also get the same error message.
( Unknown data type (28) ) : D:\Projects\Delphi\Dbx\Source\dbx.pas line 1269 )

-Windows 2000
-Delphi 7
-Freshly bought and downloaded dbexpress 2.6.7 driver
-MySQL 5.0.13 ( libmysql.dll 1412KB 2005/09/22 )

[PaulG]

They managed to reproduce the problem with a sample I sent to them, and they said a fix would be in the next build. That was on the 2nd of November and they said the build would be available in about 1 month.

[Ikar]

Hi

I'm having exactly the same issue as described above. No problem to normally open clientdataset for a table with decimal fields in it. But when you try to use the sqlDataSet.SetSchemaInfo(stColums,'tablename','') and open I also get the same error message.
( Unknown data type (28) ) : D:\Projects\Delphi\Dbx\Source\dbx.pas line 1269 )

-Windows 2000
-Delphi 7
-Freshly bought and downloaded dbexpress 2.6.7 driver
-MySQL 5.0.13 ( libmysql.dll 1412KB 2005/09/22 )

We have in plans to release new build this week. But if you send us (dbxmda*crlab*com) complete small sample we will try to check the problem with SetSchemaInfo more detailed.