_dbcolumns, _dbforeignkey, _dbprimarykey, _dbtables

Format: _dbcolumns (table-description)
Format: _dbforeignkey (table-description [ , table-description ])
Format: _dbprimarykey (table-description)
Format: _dbtables ()
Format: _dbtypes ([ sql type])

Purpose: Get data definition information about database tables and database types. The table-description argument must be an object and is usually an object field of the object returned by _dbtables().

Return Values: All functions return an object.

Note: These are heitml internal functions. The contents of the objects returned by these functions are not documented here, since they may change in future releases of heitml.

Example:

input:
<let t=_dbtables();
  if !isempty(t);
  forin i t;
    if ContainsCase(t[i].tablename,"guestbook");break;/if;
 /forin;
><? t[i].tablename> = (<? t[i] ",\n %tQnNn">)
columns = <? _dbcolumns(t[i])>
primary key = <? _dbprimarykey(t[i])>
</if>
DB-specific LONGVARCHAR type: <? _dbtypes(-1) >
resulting output:
GUESTBOOK = (tablequalifier=null,
 tableowner='HEIDEMO',
 tablename='GUESTBOOK',
 TABLETYPE='TABLE',
 PRIVILEGES='SEL+UPD+DEL+INS+REF+IND+ALT+',
 UNLOADED='NO',
 SAMPLE_PERCENT=null)
columns = 
[0]=(tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="GUEST_NAME", typename="CHAR", precision=50, scale=null, radix=null, NULLABLE=true)
[1]=(tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="EMAIL", typename="VARCHAR", precision=50, scale=null, radix=null, NULLABLE=true)
[2]=(tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="ADDRESS", typename="VARCHAR", precision=60, scale=null, radix=null, NULLABLE=true)
[3]=(tablequalifier=null, tableowner="HEIDEMO", tablename="GUESTBOOK", COLUMNNAME="COUNTRY", typename="VARCHAR", precision=60, scale=null, radix=null, NULLABLE=true)
[4]=
tablequalifier=null
tableowner="HEIDEMO"
tablename="GUESTBOOK"
COLUMNNAME="GUEST_COMMENT"
typename="VARCHAR"
precision=250
scale=null
radix=null
NULLABLE=true
[5]=
tablequalifier=null
tableowner="HEIDEMO"
tablename="GUESTBOOK"
COLUMNNAME="GUEST_PASSWORD"
typename="CHAR"
precision=61
scale=null
radix=null
NULLABLE=true
primary key = () DB-specific LONGVARCHAR type:
LONG=
TYPE_NAME="LONG"
DATA_TYPE=-1
precision=2147483647
LITERAL_PREFIX="'"
LITERAL_SUFFIX="'"
CREATE_PARAMS=null
NULLABLE=1
CASE_SENSITIVE=1
SEARCHABLE=0
UNSIGNED_ATTRIBUTE=null
MONEY=0
AUTO_INCREMENT=null
LOCAL_TYPE_NAME="LONG"
MINIMUM_SCALE=null
MAXIMUM_SCALE=null
SQL_DATA_TYPE=-1
SQL_DATETIME_SUB=null
NUM_PREC_RADIX=null
INTERVAL_PRECISION=null
REMARKS=null


This page was dynamically generated by the web application development tool RADpage of H.E.I.
© 1996-2017 H.E.I. All Rights Reserved.



Homepage
Intro/Features
Component Guide
Programming
  Language Guide
  Language Ref.
    General Design
    Lexical Structure
    Expressions
    Objects
    Methods
    Classes
    heitml Tags
    heitml Functions
      ArAppend
      ArConcat
      ArSearch
      array
      asc
      caltime
      chr
      class
      clone
      contains
      ContainsCase
      copy
      copyfile
      crypt
      _dbcolumns
      _dbforeignkey
      _dbprimarykey
      _dbtables
      _dbtypes
      default
      deletefile
      difftime
      directory
      findex
      flush
      fname
      gmtime
      htmlbool
      http_content_type
      http_empty_document
      http_expires
      http_header
      http_last_modified
      http_location
      http_set_cookie
      http_request_header
      _includefilepreprocessed
      index
      IndexCase
      integer
      isbool
      isdecl
      isempty
      isinteger
      isnull
      isstring
      istuple
      isreal
      left
      len
      localtime
      MD5
      mkdir
      mktime
      movefile
      offstotabcol
      random
      readFileLines
      _readini
      _readodbcdrv
      _readodbcdsn
      real
      resize
      right
      _serverdocroot
      _shelltemp
      srandom
      splitstring
      stat
      strftime
      strptime
      subst
      substall
      substring
      tabcoltooffs
      tolower
      toupper
      trim
      trimleft
      trimright
      TuAppField
      TuAssField
      TuAssign
      TuSlice
      TuDelField
      TuFieldSort
      TuInsField
      TuMerge
      TuName
      TuProject
      utime
      _writeini
    Advanced Functions
    Database Access
    Global Variables
    Form Fields
    Server Variables
    Sessions
    heitml Syntax
  Component Ref.
  Class Library
  User Components
  Tryout Form
  Tutorial
  New Features
  heitml 1
User Guide
FAQ
Mailinglist
Discussion Group
Services
Pricing/Register
Download
Frame
 
Contact
 
 
 
Search: