Devart Forums

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

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.

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 )

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.

dirkdeberlanger wrote: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.