552
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
befree 2004-08-17
- 打赏
- 举报
对，用access+ado
mysql+dbexpress
快，方便，有用
mysql+dbexpress
快，方便，有用
invalid 2004-08-17
- 打赏
- 举报
本机数据库建议使用Access
kmfangxun 2004-08-17
- 打赏
- 举报
建议不要使用Paradox ，已经被Borland Over了，Bde也要逐渐被 over掉.
ch_builder 2004-08-17
- 打赏
- 举报
Create Paradox Table dialog box
See also
Use the Create Paradox Table dialog box to specify the structure of a Paradox table.
This dialog box has two main panels: Field Roster and Table Properties. You can move between them using the keyboard: Use the Super Tab key (F4) to move from Field Roster to Table Properties; to return, press Shift+Tab.
To open this dialog box, choose a Paradox table format in the Create Table dialog box.
Dialog box options
Field Roster
Use the Field Roster to specify the fields of a table. You can add, delete, or rename fields, and change field types and sizes.
To insert a field between two existing fields in the Field Roster, select a field and press Ins. Database Desktop opens a blank row above the selected field.
To delete a field from the Field Roster, select it and press Ctrl+Del. Database Desktop deletes the entire row.
The order in which fields are listed in the Field Roster is the order in which the fields appear in the table. To change the field order, click the row number of the field and drag it to a new position.
Field Name
Specifies the name of the field. See Rules for Paradox field names for more information. This is a required field.
Type
Specifies the type of the field. Right-click the Type column or press the Spacebar to display a list of field types. See Paradox field types and sizes for more information. This is a required field.
Size
Specifies the size of the field. See Paradox field types and sizes for more information. This is a required field for some field types.
Key
Specifies whether the field is a key field. The table type determines rules for Paradox key fields. See About primary indexes (key fields) for more information.
Table Properties
In the Table Properties panel you can specify the following:
Validity Checks
Specifies requirements and defaults for a field. You must have a valid entry selected in the Field Roster area to specify validity check information. For more information about validity checks, see About validity checks.
You can specify the following types of validity checks:
Required Field: Specifies that the selected field in the Field Roster is a required field. When a field is required, you must enter a value in the field for every record in the table. See About required fields for more information.
Minimum: Specifies a minimum value for the selected field in the Field Roster. When a field has a minimum validity check, the values entered in the field must be greater than or equal to the minimum you specify here. See About minimum and maximum values for more information.
Maximum: Specifies a maximum value for the selected field in the Field Roster. When a field has a maximum validity check, the values entered in the field must be less than or equal to the maximum you specify here. See About minimum and maximum values for more information.
Default: Specifies a default value for the selected field in the Field Roster. When a field has a default validity check, Database Desktop enters the value you specify here if you do not enter another value when you edit this field. See About default values for more information.
Picture: Restricts the types of information you can enter in a field. When a field has a picture validity check, you specify a character string as a template for the values that can be entered into this field. See About pictures for more information.
Assist: Opens the Picture Assistance dialog box, where you can select or modify a predefined string to use as a picture.
Table Lookup
Specifies a lookup table for the current field in the Field Roster. A lookup table is another table that contains values that are valid for the current field. See About table lookups for more information.
Choose Table Lookup, then choose Define to open the Table Lookup dialog box.
Secondary Indexes
Creates a secondary index on the current field in the Field Roster. A secondary index lets you sort data in an order different from the key field, and lets you form links between tables. See About secondary indexes for more information.
Choose Secondary Indexes, then choose Define to open the Define Secondary Index dialog box.
Referential Integrity
Creates a referential integrity relationship between the current field and the key field in another table. A referential integrity relationship ensures that ties between like data in separate tables cannot be broken. See About referential integrity for more information.
Chose Referential Integrity, then choose Define to open the Referential Integrity dialog box.
Password Security
Creates passwords to protect your tables from unauthorized access. See About password security for more information.
Choose Password Security, then choose Define to open the Password Security dialog box.
Table Language
Specifies the language driver. See About table language drivers for more information.
Choose Table Language, then choose Modify to open the Table Language dialog box.
Dependent Tables
Displays all tables that depend on the current table for referential integrity.
Borrow
Specifies whether to create this table structure by using the structure of another table as a template. Choose Borrow to open the Select Borrow Table dialog box and choose from the list of tables. The Field Roster must be empty to borrow another table's structure.
Save As
Saves the table you are creating and closes the Create Paradox Table dialog box. Choose Save As to open the Save Table As dialog box, where you type a name for your new table. You can save the table in the current directory or another one.
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.
See also
Use the Create Paradox Table dialog box to specify the structure of a Paradox table.
This dialog box has two main panels: Field Roster and Table Properties. You can move between them using the keyboard: Use the Super Tab key (F4) to move from Field Roster to Table Properties; to return, press Shift+Tab.
To open this dialog box, choose a Paradox table format in the Create Table dialog box.
Dialog box options
Field Roster
Use the Field Roster to specify the fields of a table. You can add, delete, or rename fields, and change field types and sizes.
To insert a field between two existing fields in the Field Roster, select a field and press Ins. Database Desktop opens a blank row above the selected field.
To delete a field from the Field Roster, select it and press Ctrl+Del. Database Desktop deletes the entire row.
The order in which fields are listed in the Field Roster is the order in which the fields appear in the table. To change the field order, click the row number of the field and drag it to a new position.
Field Name
Specifies the name of the field. See Rules for Paradox field names for more information. This is a required field.
Type
Specifies the type of the field. Right-click the Type column or press the Spacebar to display a list of field types. See Paradox field types and sizes for more information. This is a required field.
Size
Specifies the size of the field. See Paradox field types and sizes for more information. This is a required field for some field types.
Key
Specifies whether the field is a key field. The table type determines rules for Paradox key fields. See About primary indexes (key fields) for more information.
Table Properties
In the Table Properties panel you can specify the following:
Validity Checks
Specifies requirements and defaults for a field. You must have a valid entry selected in the Field Roster area to specify validity check information. For more information about validity checks, see About validity checks.
You can specify the following types of validity checks:
Required Field: Specifies that the selected field in the Field Roster is a required field. When a field is required, you must enter a value in the field for every record in the table. See About required fields for more information.
Minimum: Specifies a minimum value for the selected field in the Field Roster. When a field has a minimum validity check, the values entered in the field must be greater than or equal to the minimum you specify here. See About minimum and maximum values for more information.
Maximum: Specifies a maximum value for the selected field in the Field Roster. When a field has a maximum validity check, the values entered in the field must be less than or equal to the maximum you specify here. See About minimum and maximum values for more information.
Default: Specifies a default value for the selected field in the Field Roster. When a field has a default validity check, Database Desktop enters the value you specify here if you do not enter another value when you edit this field. See About default values for more information.
Picture: Restricts the types of information you can enter in a field. When a field has a picture validity check, you specify a character string as a template for the values that can be entered into this field. See About pictures for more information.
Assist: Opens the Picture Assistance dialog box, where you can select or modify a predefined string to use as a picture.
Table Lookup
Specifies a lookup table for the current field in the Field Roster. A lookup table is another table that contains values that are valid for the current field. See About table lookups for more information.
Choose Table Lookup, then choose Define to open the Table Lookup dialog box.
Secondary Indexes
Creates a secondary index on the current field in the Field Roster. A secondary index lets you sort data in an order different from the key field, and lets you form links between tables. See About secondary indexes for more information.
Choose Secondary Indexes, then choose Define to open the Define Secondary Index dialog box.
Referential Integrity
Creates a referential integrity relationship between the current field and the key field in another table. A referential integrity relationship ensures that ties between like data in separate tables cannot be broken. See About referential integrity for more information.
Chose Referential Integrity, then choose Define to open the Referential Integrity dialog box.
Password Security
Creates passwords to protect your tables from unauthorized access. See About password security for more information.
Choose Password Security, then choose Define to open the Password Security dialog box.
Table Language
Specifies the language driver. See About table language drivers for more information.
Choose Table Language, then choose Modify to open the Table Language dialog box.
Dependent Tables
Displays all tables that depend on the current table for referential integrity.
Borrow
Specifies whether to create this table structure by using the structure of another table as a template. Choose Borrow to open the Select Borrow Table dialog box and choose from the list of tables. The Field Roster must be empty to borrow another table's structure.
Save As
Saves the table you are creating and closes the Create Paradox Table dialog box. Choose Save As to open the Save Table As dialog box, where you type a name for your new table. You can save the table in the current directory or another one.
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.
3xcom 2004-08-17
- 打赏
- 举报
分有点少，请笑纳。谢谢各位。
