I customize A free table, such as A field definition for 30 characters long, but in the form form control input anyway don't lose 30 characters, to more than 10 cursor will not move back, it's strange that I wrote A piece of code to import data from Excel, can to the table to import so many characters, A column can also be normal import 30 characters long, and view the free table field structure, this column is 30.

I wonder if you have this kind of situation?

CodePudding user response:

Happens on the char or varchar type of field?

CodePudding user response:

Reconstruction of the control

CodePudding user response:

Free table field regulation should not exceed 10 characters,
No limitation for temporary table (cursor), such as
The create cursor tt (a1234567890 c (10)) & amp; & Can, field length 11
The create table tt (a1234567890 c (10)) & amp; & error

CodePudding user response:

Insert data in the window directly, to hit the post,

CodePudding user response:

maxlength

CodePudding user response:

reference 5 floor xuzuning reply:

maxlength

yes, set this property for controls

CodePudding user response:

Thank you for your reply, New Year's day home,
The free list is to dynamically generate custom table structure, and finally through the form at the interface between the input data, the character I was using a varchar