|
|
There
are several cases to use Key Fields Editor:
Add some field here to allow FSave build right Table creation sentence. For instance,
add here autoincremented fields that does not take values from form fields
Add key field. When You have a table with relationship to another table it means
that the table has some field contains keys from that relative table. You may
pass value to this field through hidden form field
Add calculated field. SP.DE could only fill table fields from some variable. So
You should add calculated field here, set their value like _CLCFIELD['test1']
and prepare $_CLCFIELD['test1'] in MySQL before action
|
|
Field name top
Enter a name of key or calculated field
|
Field MySQL type top
Set MySQL type, available types described in MySQL part |
Insert button top
Use to insert field above |
Delete button top
Use to delete this key or calculated field |
Insert mark top
Check if You need to place something into during insert operation |
Insert value top
Print a variable name to get value from or value self or MySQL expression. Variable
name (not value) must begins from $ or _ sign. For example, assume that You
have
hidden
form field
Test1. Print $_POST['Test1'] or _POST['Test1'] here to fill key field |
Update mark top
No - dont need to fill this field during update action
Values - fill from Update value
Where - field is a key, use this field in MySQL WHERE part, get a key value from
Update
value |
Update value top
Print a variable name to get value from or value self. Variable name (not value)
must begins from $ or _ sign. For example, assume that You have hidden form field
Test1. Print $_POST['Test1'] or _POST['Test1'] here to fill key field |
Add button top
Use to add one more field |
Post button top
Save changes. Exit |
Cancel button top
Cancel changes. Exit |
