[root] Log of /trunk/net/net/inc/TSQLColumnInfo.h

Revision 23091 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Wed Apr 9 15:04:27 2008 UTC (6 years, 9 months ago) by rdm
File length: 2563 byte(s)
Copied from: trunk/net/inc/TSQLColumnInfo.h revision 23090
Diff to previous 20882

moving the follwing directories to "net":

alien, auth, glite, globusauth, krb5auth, ldap, monalisa, net, netx,
rootd, rpdutils, srputils, xrootd

Revision 20882 - (view) (download) (as text) (annotate) - [select for diffs]
Modified Mon Nov 19 11:31:26 2007 UTC (7 years, 2 months ago) by rdm
Original Path: trunk/net/inc/TSQLColumnInfo.h
File length: 2563 byte(s)
Diff to previous 19826

Set property svn:eol-style LF on all source and Makefiles. This should avoid
problems with Win32 line endings ending up in the repository. All MS tools
support LF eols fine.

Revision 15305 - (view) (download) (as text) (annotate) - [select for diffs]
Added Fri Jun 2 14:02:03 2006 UTC (8 years, 7 months ago) by brun
Original Path: trunk/net/inc/TSQLColumnInfo.h
File length: 2627 byte(s)

From Sergey Linev:
1. New methods of TSQLServer class (also for Oracle, MySQL, ODBC):
     Exec() - execute query which does not produce any result
     GetTablesList() - return list of tables names in data-base independent form
     IsTableExists() - check if table of given name exists
     GetTableInfo() - returns instance of TSQLTableInfo with list of columns.
2. New methods of TSQLStatement class (also for Oracle, MySQL, ODBC):
     IsNull() - checks, if field value is NULL
     SetNull() - sets parameter value to NULL


New TSQLTableInfo contains information about table and table columns.
For MySQL additional information like engine type, creation and last update time is provided


New TSQLColumnInfo class contains information about single column from SQL table
Has following methods:
   GetTypeName() - field type name in string form as it is reported by correspondent
          database method. Some databases providing full type name like "numeric(20)",
          other showing only "NUMERIC". As a result, one cannot use this string directly
          to create new field of similar types in other table
   IsNullable() - says if field value can be NULL or not
   GetSQLType() - returns kind of sql type. Possible values:
      TSQLServer::kSQL_NONE        data type unknown
      TSQLServer::kSQL_CHAR        CHAR(n) - string with fixed length n
      TSQLServer::kSQL_VARCHAR     VARCHAR(n) - string with variable length upto n
      TSQLServer::kSQL_INTEGER     INTEGER, INT, TINYINT - any integer types
      TSQLServer::kSQL_FLOAT       FLOAT - float value
      TSQLServer::kSQL_DOUBLE      DOUBLE - double precision value
      TSQLServer::kSQL_NUMERIC     NUMERIC(n,s), NUMBER(n,s) - numeric values with length and precion
      TSQLServer::kSQL_BINARY      BLOB, VARBINARY  - binary data (vriable or fixed size)
      TSQLServer::kSQL_TIMESTAMP   TIMESTAMP - time and date stamp
   GetSize() - size of field in database. -1 if not known.
   GetLength() - length argument in type declaration like CHAR(len) or NUMERIC(len), -1 if not defined
   GetScale() - second argument in declarations like NUMERIC(len, s), -1 if not defined
   GetSigned() - is type signed(==1) or unsigned(==0), -1 if not defined

This form allows you to request diffs between any two revisions of this file. For each of the two "sides" of the diff, enter a numeric revision.

Links to HEAD:	(view) (download) (as text) (annotate)
Sticky Revision: