Devart Forums

Hi,

SHOW CREATE TABLE TEST.DEPT reports message "invalid field size"
meaning that the TStringfield size exceeds dsMaxStringsize (8192) characters.

I've noticed this error and similar SHOW ... output problems have been solved on multiple previous versions ?
My version is only a trial version at this point, maybe that's why ?

Hope you fix it (even for the trial version)

Thanks.

I can not reproduce the problem.
Please supply me the following information:
- the exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor;
- the exact version of your IDE;
- the exact version of MySQL server and client. You can see it in the Info sheet of TMyConnection Editor.

=============================
MyDAC v5.90.0.57 for Delphi 5 (Trial Edition)
Delphi v5.0 (build 6.18) update pack 1
MySQL server version: 5.1.46-community
MySQL client version: Direct
=============================

As mentioned this occurs in the Trial Edition,
when tried on the compiled demo it does not fail.

Ok, I think I located the problem...
The default value of TMyQuery.Options.LongStrings is TRUE, when running the program with LongStrings is FALSE it works.
So obviously your LongStrings solution is doing something wrong here.

Why are you using default options that do not agree with standard MySQL behaviour ???
Options.LongStrings default TRUE (should be FALSE)
Options.EnableBoolean default TRUE (should be FALSE)
Options.CreateConnection default TRUE (should be FALSE)
and these are only the ones I've located up until now...

And why is OptimizedBigInt defined on the connection, where EnableBoolean (a similar option) is defined on the dataset ?
(that seems to be inconsistent)

Anyway...

Replicate:
1. drop a TMyConnection on a form
2. drop a TMyQuery on a form
3. drop a TButton on a form
4. code TButton.onClick to be MyQuery1.active := true
5. run and click on the button

1. TMemDataset.CreateFieldDefs is trying to create a TFieldDef of type DB.TStringField
2. DB.TStringField.CheckTypeSize checks the desired size to be <= dsMaxStringSize, which is defined as 8192
3. DatabaseError(SInvalidFieldSize) is triggered ("invalid field size")

Relevant debug output:
[/code]

Thank you for information. This problem is reproduced only for Delphi 5. We have fixed it. This fix will be included in the next MyDAC build.