Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: MIDAS Not Allow Field Name Length more than 31 Chars



Permlink Replies: 0
Bear Xu

Posts: 10
Registered: 5/22/06
MIDAS Not Allow Field Name Length more than 31 Chars
Click to report abuse...   Click to reply to this thread Reply
  Posted: Feb 22, 2016 8:19 PM
Dear All,

Oracle not allow 31 chars for field name, but MySQL, SQL Server, Access etc allow the field name to be much more .
We use Access, and the field name should be same as the text on the web page fill out form, also should be unicode. We found it failed to save the data.
because Midas not allow it. Delphi 10 Seattle Enterprise.

31 character equal 10 Chinese Character, too few to the users.

DataSnap.DSIntf
{ Field Descriptor }
DSFLDDesc = record
szName : MIDASNAME; { Field name }
iFldType : Integer; { Field type }
iFldSubType : Integer; { Field subtype (if applicable) }
iUnits1 : Integer; { Number of Chars, precision etc }
iUnits2 : Integer; { Decimal places etc. }
iFldLen : Integer; { Length in bytes (computed) }
iFldOffsInRec : Integer; { Offset to field in record buffer }
iNullOffsInRec : Integer; { Offset to null flag (1byte) in record buffer }
iFieldID : Word; { FieldID of this field }
iFieldIDParent : Word; { FieldID of parent, if any (part of ADT or ARRAY) }
bCalculated : LongBool; { Field is Calculated }
iFldAttr : Integer; { Field attributes }
iOptParameters : Integer; { Number of optional parameters for field }
end;

{$IFNDEF NEXTGEN}
MIDASNAME = packed array [0..31] of AnsiChar; { holds a name }
MIDASPATH = packed array [0..260] of AnsiChar; { holds a DOS path }
{$ELSE}
MIDASNAME = packed array [0..31] of Byte; { holds a name }
MIDASPATH = packed array [0..260] of Byte; { holds a DOS path }
{$ENDIF !NEXTGEN}

also pls check this :
http://codeverge.com/embarcadero.delphi.multi-tier/unicode-problems-with-clientdat/1096706

Edited by: Bear Xu on Feb 22, 2016 8:26 PM

Edited by: Bear Xu on Feb 22, 2016 9:16 PM

Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02