Watch, Follow, &
Connect with Us
Public Report
Report From: Kylix/Database    [ Add a report in this area ]  
Report #:  7877   Status: Reported
Column-names longer than 31 characters produce errors
Project:  Kylix Build #:  4.186
Version:    3.0 Submitted By:   Registered User
Report Type:  Basic functionality failure Date Reported:  4/14/2004 2:07:02 AM
Severity:    Critical / Show Stopper Last Updated:
Platform:    Kylix C++ IDE Internal Tracking #:  
Resolution: None  Resolved in Build: : None
Duplicate of:  None
Voting and Rating
Overall Rating: (1 Total Rating)
4.00 out of 5
Total Votes: None
Description
Working with MySQL-tables, which contain column-names longer than 31 characters produce errors when uses with TSqlClientDataset.

An exception is thrown, and an error-message pops up, which points out that there are more than 31 characters.

Unfortunatly, the limitation seems to be in the libmidas-library, which come as binary-only.

Column-names in MySQL may have up to 64 characters.
Steps to Reproduce:
Use a TSQLClientDataset, TSQLConnection an a TDBGrid and connect to a MySQL-database with columnnames longer than 31 characters.
Workarounds
At the moment, I am suppressing the exception in the file "clx/Provider.pas",
Method "TDataPacketWriter.AddColumn" near line 1095.

This way the column-names are truncated to 31 characters
and the datasensitive-components can continue displaying the data.
Attachment
None
Comments

None

Server Response from: ETNACODE01