paradox有可输入大于600字符以上字符字段吗?(100分)

  • 主题发起人 主题发起人 kevin_m
  • 开始时间 开始时间
K

kevin_m

Unregistered / Unconfirmed
GUEST, unregistred user!
paradox有可输入大于600字符以上字符字段吗?
 
用Paradox的 Memo 字段
Use memo fields for text strings that are too long to store in an
alpha field.
Memo fields can be virtually any length. The size value you assign
refers to the amount of the memo Database Desktop stores in the
table. This can be from 1 to 240 characters. Database Desktop stores
the whole memo outside the table (in the .MB file). Database Desktop
retrieves the data from the .MB file as you scroll through the records
of the table. The amount of data a memo field contains is limited only
by the disk space available on your system.
 
以下是paradox的帮助

Paradox max record : 20亿
Paradox max filed : 255
Paradox record max char :32750


Paradox field types and sizes

See also

The valid Paradox field types and sizes are

Symbol Size Type



A 1 - 255 Alpha
N Number
$ Money
S Short
I Long Integer
# 0 - 32* BCD
D Date
T Time
@ Timestamp
M 1 - 240** Memo
F 0 - 240** Formatted Memo
G 0 - 240*** Graphic
O 0 - 240*** OLE
L Logical
+ Autoincrement
B 0 - 240*** Binary

Y 1 - 255 Bytes

* Number of digits after the decimal point
** Memo and formatted memo fields can be virtually any length. The value
you specify in the Create Table dialog box refers to the amount of the memo
Database Desktop stores in the table (1 to 240 characters for memos and 0
to 240 characters for formatted memos). The entire memo is stored outside
the table. For example, if you assign a size value of 45 to the field,
Database Desktop stores the first 45 characters in the table. It stores
the whole memo field in another file (with the extension .MB) and retrieves
it as you scroll through the records of the table.

*** Optional

Tip: If all your memos are smaller than a given size (for example,
200 characters), you can save space and time by setting the memo field
size equal to or larger than this size. Database Desktop stores the entire
memo in the table if it is less than the given size.





 
后退
顶部