BLHTML.org

BLHTML.org / Web Programming / BLHTML / BLHTML Manual / BLHTML funktion list / BLHTML funktion list /

 
  FIELDMIN 2931 0
#FIELDMIN# is an admin, database function
Rights to use this function #FIELDMIN#:
  • Data manager
  • Users with Data Manager manage only eget account

  • #FIELDMIN# Fält Administration, insert, update and delete field in en table.
    Kan även radera all field in en table.
    Första field in table är alltid ett key field, som standard är fieldname id.

    values:  contents:  description:
    idcurrent accountDatapage som skall Administreras
    nameName on field
    change_namenameNewtt field name
    keyfalse
    true
    Vanligt field
    Key Field måste vara unikt and contains värde (table can contains flera key field)
    typeH1
    H2
    H3
    H4
    H8
    F4
    F8
    str
    text
    -128 -- 127 (0 -- 255) 1 byte
    -32768 -- 32767 (0 -- 65535) 2 bytes
    -8388K -- 8388K (0 -- 16777K) 3 bytes
    -2.147G -- 2.147G (0 -- 4.294G) 4 bytes
    -9223372036G -- 9223372036G (0 -- 18446744073G) 8 bytes
    Flyttal 4 bytes
    Flyttal 8 bytes
    1 to 255 characters string
    65535 characters lång string
    len32type=str size on a stringfield in characters (1 to 255 characters)
    signedfalse
    true
    Only plusstal
    plus and minus
    nullfalse
    true
    Fält can ej vara tomt (måste contains värde)
    Fält can vara tomt
    defaultValue som skall sättas vid new post
    actionsave
    erase
    drop
    create/update field
    delete field
    delete hela table
    auto_incrementfalse
    true
    Sätter standard värde
    Create a new unikt number

    Example: Create Table to ett new standard forum
    #FIELDMIN name(id) key=true type=H8 null=false auto_increment=true#
    #FIELDMIN name(user) type=str len=16#
    #FIELDMIN name(grp) default(1)#
    #FIELDMIN name(date) type=str len=10#
    #FIELDMIN name(up) type=H2#
    #FIELDMIN name(rubric) type=str len=42#
    #FIELDMIN name(msg) type=text#
    #FIELDMIN name(status) default(1)#
    #FIELDMIN name(who) type=H8#
    #FIELDMIN name(tree) default(1)#
    #FIELDMIN name(edit) default(1)#
    #FIELDMIN name(edited) type=str len=10#
    #FIELDMIN name(visitors) type=H2#
    #FIELDMIN name(IP) type=str len=15#
    #FIELDMIN name(last) type=str len=16#
    #FIELDMIN name(ldate) type=str len=11#


    // Field id create automatic to #FIELDMIN name(id) type=H1 key=true null=false#
    // Erase active table: #FIELDMIN action=drop#

    Fältet id create automatiskt to #FIELDMIN name(id) type=H1 key=true null=false#
    Delete current table: #FIELDMIN action=drop#

    More information:
  • #INSERT#
  • BLHTML forum  


    apache MySQL PHP No to software patents! BLHTML
    © 2003, 2010 BLHTML
    This page is created with BLHTML in 0.1278 seconds