Package generalDatabase

Class MSAccessSQLTypes

java.lang.Object

generalDatabase.SQLTypes

generalDatabase.MSAccessSQLTypes

public class MSAccessSQLTypes
extends SQLTypes

Constructor Summary

Constructors

Constructor	Description
MSAccessSQLTypes()

Method Summary

Modifier and Type	Method	Description
String	formatColumnName(String columnName)	Format the column name.
int	systemSqlType(int sqlType)	Some SQL types are unavailable on some systems, so qutomatically swap them for something else.
String	typeToString(int sqlType, int length, boolean counter)

Methods inherited from class generalDatabase.SQLTypes

createTableItem, formatColumnName, formatDateTimeMatchString, formatDBDateTimeQueryString, formatTableName, getLocalTimeStamp, getLongValue, getTimeStamp, isAllowBlanks, makeDouble, makeDouble, makeFloat, makeFloat, makeInList, millisFromTimeStamp, setAllowBlanks, stringToLength, stringToType, typeToString, typeToString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

MSAccessSQLTypes

public MSAccessSQLTypes()

Method Details

typeToString

public String typeToString(int sqlType,
 int length,
 boolean counter)

Overrides:

typeToString in class SQLTypes

formatColumnName

public String formatColumnName(String columnName)

Description copied from class: SQLTypes

Format the column name. Formats may be slightly different for different DBMS's. e.g. MS Access can put quotes around names. OODB requires them to be all upper case, etc.

Overrides:

formatColumnName in class SQLTypes

Parameters:

columnName -

Returns:

formatted column name.

systemSqlType

public int systemSqlType(int sqlType)

Description copied from class: SQLTypes

Some SQL types are unavailable on some systems, so qutomatically swap them for something else.

Overrides:

systemSqlType in class SQLTypes

Parameters:

sqlType -

Returns: