view release on metacpan or  search on metacpan

lib/CGI/Bus/tmsql.pod  view on Meta::CPAN

Field name, unique in the C<Form Description>, used as L<CGI|CGI> param name
with or without prefix like C<-pxpv>


=item -flg

Field flags string:

 'a'll - use in all operations below (except 'f'etch, 'k'ey and below)

 'c'reate - create new record
 'e'dit   - edit record and field
 'v'iew   - view record or  field
            'av' - always view only, not edit
            'cv' - view only when new record created
            'ev' - view only when record is edited
 'l'ist   - list records
 'f'etch  - fetch only when list
 'q'uery  - query condition form to list records

 'i'nsert - insert to database
 'u'pdate - update in database
 'd'elete - delete in database           (reserved)
 's'elect - select from database

 'k'ey       - key field, use to open record from list of records
 'w'here key - use field along with key in update or delete condition
               for optimistic locking
 'm'andatory - value is required
 'g'enerated - value is generated by database
 '"',"'"     - quote method of the value ('[' reserved)
 'n'umeric   - numeric value             (reserved)



=item -frm

Compute field value sub{}
to evaluate on C<-chk> or C<-frm> command.
See also C<-sav>


=item -hide

Hide field from Form (C<-frm>) condition sub{}


=item -hidel

Hide field from Form (C<-frm>) condition sub{}.
Fields at the right will be shifted to the left.


=item -inp

Input or edit HTML widget description:
-inp=>{?attributes} or -inp=>[input_type => {?attributes}].
Short form may be used to describe 
'textfield' or 'htmltextfield', 
'textarea' or 'htmltextarea', 
or 'popup_menu'.
C<-htmlopt> => 1 attribute causes to use data as HTML if 
HTML formatting detected with C<ishtml> L<CGI::Bus|CGI/Bus> method.
'htmltextarea' URLs display behaviour is extended with 
special URL protocol 'fsurl://' to be translated to C<fsurl> value.
See also L<CGI::Bus|CGI/Bus> for 'htmltextfield' and 'htmltextarea'
attributes.


=item -inphtml

Input/edit widget HTML background. Value or sub{} to compute it.
HTML code to place into form with HTML widget C<-inp> embedded.
May contain 'TD' or 'TH' HTML tags.
'$_' marks the insertion point for widget.
See also C<htmlddlb>.


=item -ins

Insert field value, sub{} or value, computed inside C<cmdchk>
under C<-ins> command. See also C<-upd>, C<-del>, C<-sav>.


=item -lbl

=item -lbl_LNG

Field label.
External name of the field to use 
in list of records (C<-lst>) or form (C<-frm>).
LNG is C<lngname>


=item -lblhtml

Label HTML background. Value or sub{} to compute it.
HTML code to place into form with field label C<-lbl> embedded.
May contain 'TD' or 'TH' HTML tags.
'$_' marks the insertion point for label.


=item -null

NULL or undefined value to present


=item -qry

Default query condition.
Default value for query condition for the list of records.
Sub{} or value.


=item -sav

Field value or sub{} to compute it before data save - 
C<-ins>, C<-upd>, C<-del> - 
for computed when saved fields, inside C<cmdchk>.
Computed fields may be implemented via C<-frm> sub.
See also C<-cdbC>, C<-frm>.