dbDBType

Set the DB type. Default DBType is ACCESS.

Property Syntax

Obj.dbType=="ACCESS(def)|SQL|ORACLE|SYBASE|FOXPRO|EXCEL|TXT|DB2"

Example

X.dbDBType="SQL"
X.dbDBType="ORACLE"

Notes

DB Type Left Right Default Date Format
ACCESSSQL ' ' [MM/DD/YYYY HH:MM:SS]
ACCESS # # [MM/DD/YYYY HH:MM:SS]
SQL, SQL65 ' ' [MM/DD/YY HH:MM:SS]
MYSQL ' ' [YYYY-MM-DD HH:MM:SS]
SYBASE ' ' [YYYY/MM/DD HH:MM:SS]'
ORACLE ' ' TO_DATE('[DD-MMM-YYYY HH:MM:SS]','DD-MON-YYYY HH24:MI:SS')
DB2 ' ' [MM/DD/YY HH:MM:SS]
FOXPRO { } MM/DD/YY HH:MM:SS
EXCEL", "TEXT", "TXT"     MM/DD/YY