- a certain Table cannot be selected
- this Table has a DECIMAL Field - the only one of all my MySql Tables
- this does not happen with the same Table in MySql 4.1.9, Access or MsSql
- this happens when using UniDirect or a 'Select * from something' with the MySqlDirect Table Sample
- the 'MySql Query Browser 1.1.5' can select and show the Table with no errors.
This problem also accours after creating the following Table :
CREATE TABLE TestDecimal
(
id INT(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
Profession VARCHAR(200) NOT NULL DEFAULT '' COMMENT 'Test String',
Preis DECIMAL(19,4) DEFAULT 0 COMMENT 'Test Decimal Problem',
Datum DATE NOT NULL DEFAULT '0000-00-00' COMMENT 'Test Date',
PRIMARY KEY (id),
KEY id (id),
INDEX (id)
) TYPE=InnoDb COMMENT='Test Table for MySql 5.0.4 Problem.' ;
The select Command (Fill) will also fail with the following Messages :
--> Specified method is not supported
Any further attemt to use the Connection will cause the following Message
--> Net packets out of order: received[101], expected[1]
In my Database Program this started when attemting to do the following :
- uni_Command.CommandText = "SELECT * FROM `software_inventur` ; "
- uni_DataReader = uni_Command.ExecuteReader();
--> Specified method is not supported
- dt_Schema = uni_DataReader.GetSchemaTable();
After two attemts to use the connection (also with a new Command and Reader) where the 'Net packets ..'
come, the program dies (i.e. no longer reacts) despite the try / catch attempts.
Leaving out this Table, everything works.
It is also possible to retrieve results from ;
- 'SELECT COUNT(*) FROM software_inventur'
- 'SELECT ID FROM software_inventur'
- from this Table with the correct results.
But once a 'select *' or a 'select Preis FROM software_inventur' (the Field with the DECIMAL)
- it will fail.
Since it all works in 'MySql Query Browser 1.1.5', I must assume the error lies elsewere.
My main Problem is that the Programs dies when this accurs.
Mark Johnson, Berlin Germany
[email protected]